Skip site navigation (1) Skip section navigation (2)

Re: audit trigger (update)

From: Wim Bertels <wim(dot)bertels(at)khleuven(dot)be>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: <pgsql-www(at)postgresql(dot)org>
Subject: Re: audit trigger (update)
Date: 2011-06-13 18:32:59
Message-ID: 1307989979.2354.1.camel@Piepoeh (view raw or flat)
Thread:
Lists: pgsql-www
Robert Haas schreef op ma 13-06-2011 om 01:03 [-0400]:
> On Wed, Jun 8, 2011 at 11:52 AM, Wim Bertels <wim(dot)bertels(at)khleuven(dot)be> wrote:
> > Hallo,
> >
> > on
> > http://wiki.postgresql.org/wiki/Audit_trigger
> >
> > the
> > RETURN NULL
> > in the delete part of the trigger
> > should be
> > RETURN OLD
> 
> I don't think it matters, does it?

yes it does,
otherwise this audit_trigger cancels delete statements
(as it is processed before in this example)

mvg,
Wim

> 




In response to

pgsql-www by date

Next:From: Greg SmithDate: 2011-06-13 18:47:22
Subject: Re: Fwd: [Announce] PostgreSQL Update from Command Prompt, Inc.
Previous:From: Joshua D. DrakeDate: 2011-06-13 18:30:42
Subject: Re: Fwd: [Announce] PostgreSQL Update from Command Prompt, Inc.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group