"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