On Oct 11, 2009, at 10:51 AM, Naoko Reeves wrote:
Could you tell me if there is a way to know if trigger is invoked by the code from another trigger? For instance, table A Trigger deletes table B record. While in table B trigger, I want to know whether this was triggered from table A.
Nothing built in to show you that. You could, however, have your trigger on table A make an insert or update to a record in some table that the trigger on table B could then look for.
Erik Jones, Database Administrator Engine Yard Support, Scalability, Reliability 866.518.9273 x 260 Location: US/Pacific IRC: mage2k -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
