Re: audit table containing Select statements submitted - Mailing list pgsql-hackers

    Do we have any plans of introducing 'AUTONOMOUS TRANSACTION'  like feature?
   Again, it might not be a part of the standard.... but it is very
helpful in situations like these!!! You can run a trigger with an
autonomous transaction attached to it, which guarantees that the work
done by trigger persists even though the calling transaction rolls
back (potentially a hacker trying to cover his tracks)!!!

(http://asktom.oracle.com/~tkyte/autonomous/index.html)

Gurjeet.

On 5/16/06, Josh Berkus <josh@agliodbs.com> wrote:
> Doug,
>
> > But what if the user calls the access function, sees the data, then
> > issues a ROLLBACK?  The audit record would be rolled back as well (as
> > Tom pointed out earlier).