Jay Parker <[EMAIL PROTECTED]> writes:
> I am revisiting the age-old audit table issue, and am curious to see 
> whether I can get away with not writing custom trigger functions for 
> every table being audited.

You can't do it nohow in plpgsql.  I believe it's relatively simple in
pltcl or plperl, though, because those languages don't try to precompile
column references.

Or if you're feeling bold, you could write the trigger in C ;-).
There are some examples that do pretty similar stuff in contrib/spi/.
If performance is a big concern this would be a good plan anyway.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to