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.at tname%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"
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.at tname%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"