By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,084 Members | 1,969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,084 IT Pros & Developers. It's quick & easy.

How i can scan OLD and NEW trigger's record?

P: 1
Hi all :-)
how i can scan the NEW or OLD record that postgres create when a trigger start?


i want the value and the name of the key of the OLD/NEW record (because i don't know the table tha fire the trigger).

i have think to scan pa_attribute with the name of the table and save it the variable col pg_attribute.attname%TYPE

after i loop the name of the column from col but when i use NEW.col i have the error: il record "new" non ha un campo "col"
Feb 10 '14 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.