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
