Postgres Pro
Downloads
Home   >   mailing lists

Re: triggered data change violation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: triggered data change violation
Date
Msg-id 12536.985120793@sss.pgh.pa.us
Whole thread Raw
In response to triggered data change violation  (Cedar Cox <cedarc@visionforisrael.com>)
Responses Re: triggered data change violation  (Cedar Cox <cedarc@visionforisrael.com>)
Re: triggered data change violation  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view 
Cedar Cox <cedarc@visionforisrael.com> writes:
> Added note:  The trigger is a BEFORE trigger.

AFAIK the "triggered data change" message comes out of the AFTER trigger
code.  You sure you don't have any AFTER triggers on the table?  Perhaps
ones added implicitly by a foreign-key constraint?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Allowing WAL fsync to be done via O_SYNC
Next
From: Cedar Cox
Date:
Subject: pg_dump - failed sanity check, type