[SQL] access to new/old in dynamic sql for audit table

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. My design has a foo_audit schema for each schema foo containing tables to be audited, so triggers on foo.bar will insert rows

Re: [SQL] access to new/old in dynamic sql for audit table

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,