Re: Foreign key reference causes invalid DELETE trigger calls - Mailing list pgsql-general

"Andrus" <eetasoft@online.ee> writes:
> I tried following code:

> insert into klient values (1);
> update klient set kood=2 WHERE kood=3;

> In this case, foo_trig trigger is NOT executed.

Well, yes, because that UPDATE didn't change any rows of the master
table.

            regards, tom lane