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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jheinz(at)zeitwerk(dot)de
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8661: Update on all rows in table fails
Date: 2013-12-06 15:18:59
Message-ID: 10193.1386343139@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

jheinz(at)zeitwerk(dot)de writes:
> When we want to update all rows in one table, the sql executes, but didn't
> update all rows:

You've not shown us your trigger functions, but a reasonable guess would
be that one of the BEFORE UPDATE triggers is preventing some updates (by
returning NULL, or perhaps changing the row-to-be-stored).

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Stark 2013-12-06 15:44:51 Re: BUG #8661: Update on all rows in table fails
Previous Message Vitaly Tskhovrebov 2013-12-06 15:12:30 Re: BUG #8659: Broken dependencies on RHEL6 for 9.2.6 RPMs