Re: BUG #8661: Update on all rows in table fails - Mailing list pgsql-bugs

From Greg Stark
Subject Re: BUG #8661: Update on all rows in table fails
Date
Msg-id CAM-w4HMFU3X4qyOEqmDNr2kczOq01Eqok4hcxWXo7=_rH-7WNQ@mail.gmail.com
Whole thread Raw
In response to BUG #8661: Update on all rows in table fails  (jheinz@zeitwerk.de)
List pgsql-bugs
On Fri, Dec 6, 2013 at 1:43 PM,  <jheinz@zeitwerk.de> wrote:
>
> CREATE TRIGGER tsetdefault
>   BEFORE INSERT OR UPDATE
>   ON address
>   FOR EACH ROW
>   EXECUTE PROCEDURE setaddressdefault(E'\\\\7800');

Are you sure setaddressdefault() carefully returns the NEW row every
time? If it returns NULL the update will be skipped.



--
greg

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #8661: Update on all rows in table fails
Next
From: Tom Lane
Date:
Subject: Re: BUG #8659: Broken dependencies on RHEL6 for 9.2.6 RPMs