Re: BUG #8661: Update on all rows in table fails

From: Greg Stark <stark(at)mit(dot)edu>
To: jheinz(at)zeitwerk(dot)de
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #8661: Update on all rows in table fails
Date: 2013-12-06 15:44:51
Message-ID: CAM-w4HMFU3X4qyOEqmDNr2kczOq01Eqok4hcxWXo7=_rH-7WNQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Dec 6, 2013 at 1:43 PM, <jheinz(at)zeitwerk(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-12-06 15:52:48 Re: BUG #8659: Broken dependencies on RHEL6 for 9.2.6 RPMs
Previous Message Tom Lane 2013-12-06 15:18:59 Re: BUG #8661: Update on all rows in table fails