Re: [HACKERS] triggered data change violation

Cedar Cox <cedarc@visionforisrael.com> writes:
>> 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?

> Not any that I wrote.  Ok, the table def is:

> CREATE TABLE tblStSC2Options (
>         SC2OptionID int4 NOT NULL,
>         SC2OptionName character varying(50) NOT NULL CHECK (SC2OptionName<>''),
>         SC2OptionValue float4 CHECK (SC2OptionValue>0),
>         SurID character varying(50) NOT NULL REFERENCES tblStSC2 ON UPDATE 
> CASCADE ON DELETE CASCADE,                                              ^^^^^^^^^^^^^^^^^^^

Sure looks like a foreign key to me.  If you dump the table definition
with pg_dump you'll see some AFTER triggers.
        regards, tom lane