Re: Foreign key reference causes invalid DELETE trigger calls

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrus" <eetasoft(at)online(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Foreign key reference causes invalid DELETE trigger calls
Date: 2005-11-09 21:36:37
Message-ID: 19565.1131572197@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrus" <eetasoft(at)online(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message stig erikson 2005-11-09 22:02:23 8.1.0 for RH8 here
Previous Message Andrus 2005-11-09 21:30:47 Re: Best way to use indexes for partial match at