Re: Trigger function not executing - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Trigger function not executing
Date
Msg-id 12165.1044542569@sss.pgh.pa.us
Whole thread Raw
In response to Trigger function not executing  ("Donald Fraser" <demolish@cwgsy.net>)
List pgsql-bugs
"Donald Fraser" <demolish@cwgsy.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

pgsql-bugs by date:

Previous
From: "Donald Fraser"
Date:
Subject: Trigger function not executing
Next
From: Tom Lane
Date:
Subject: Re: Bug #893: Trigger causes database to crash