Re: Persistent data per connection - Mailing list pgsql-general

From Guy Rouillier
Subject Re: Persistent data per connection
Date
Msg-id CC1CF380F4D70844B01D45982E671B2348E752@mtxexch01.add0.masergy.com
Whole thread Raw
In response to Persistent data per connection  (Jeff Amiel <jamiel@istreamimaging.com>)
List pgsql-general
Jeff Amiel wrote:
> (heck, all cases) , the audit triggers themselves (when an
> update/insert/delete takes place) have to look to see if a temp table
> exists  to pull the user data from.  It wont exist in tese cases, but
> the triggers dont know this.....

Can't you catch the undefined_table exception in your trigger functions,
then create the tables if they don't exist?  We do that and it seems to
work fine.

--
Guy Rouillier


pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: TSearch2 FreeBSD
Next
From: John DeSoi
Date:
Subject: Re: help w/ a little naive brainstorming ...