Re: Begin/Commit - Mailing list pgsql-sql

From Tom Lane
Subject Re: Begin/Commit
Date
Msg-id 16729.1009598068@sss.pgh.pa.us
Whole thread Raw
In response to Re: Begin/Commit  (Marc Spitzer <marc@oscar.eng.cv.net>)
List pgsql-sql
Marc Spitzer <marc@oscar.eng.cv.net> writes:
> Would one of these conditions include deleting a row where there is
> a field that is used as a foreign-key in another table?

[ thinks ... ]  Yes, I think so.  The cases I'm familiar with involve
inserts and updates, but probably a delete on the referenced table would
fire triggers as well.  With enough pending triggers, 7.0 and 7.1 will
get slow.  See discussions of 'triggered data change violation' error
in the archives.
        regards, tom lane


pgsql-sql by date:

Previous
From: Marc Spitzer
Date:
Subject: Re: Begin/Commit
Next
From: Tom Lane
Date:
Subject: Re: Begin/Commit