Hi, I would like to be able to figure out if a table has been updated in this connection from within a C trigger.
I have already tried to the use a query with currval on the autoincremented primary key but that exits the trigger with table.currval is not yet defined in this session Is there a way to trap / ignore this error? Or a way to check if there was a transaction in this connection before. Thanks for any input. Best wishes, M __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html