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