Re: Audit Trigger puzzler

David Kerr wrote:
> On Wed, Sep 02, 2009 at 11:44:20PM -0500, Adam Rich wrote:
> - In Oracle, the way we handle audit triggers is by using Package
> - Variables.  We emulate some of that functionality in postgresql by
> - adding a custom variable to the configuration file:
> -
> - custom_variable_classes = 'mysess'
> -
> -
> - In your trigger, you could check that this variable was unset, and fall
> - back to the database user.
> -
>
> Thanks! that does seem slick, but will it work with connection pooling?
>
> Dave
>

I don't see why it wouldn't work, as long as you set reset_query_list
properly, and set the session variable the the logged in user whenever
you grab a connection from the pool.