Re: Trigger function not executing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Donald Fraser" <demolish(at)cwgsy(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Trigger function not executing
Date: 2003-02-06 14:42:49
Message-ID: 12165.1044542569@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Donald Fraser" <demolish(at)cwgsy(dot)net> writes:
> If I run SQL such as DELETE FROM tbl_user WHERE id > '20'; and there is mor=
> e than one record that meets the condition (id > '20') then I get the follo=
> wing problem. The BEFORE trigger function is only being called on the first=
> record that is being deleted

I don't believe it --- and you haven't provided any evidence to support
your claim. More than likely, this is just an error in your own trigger
code; but with no details it's pointless to speculate.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-02-06 15:29:04 Re: Bug #893: Trigger causes database to crash
Previous Message Donald Fraser 2003-02-06 11:27:13 Trigger function not executing