Re: Unexpected update behaviour

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Victor Yegorov <vyegorov(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unexpected update behaviour
Date: 2013-12-14 22:36:58
Message-ID: 5578.1387060618@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Victor Yegorov <vyegorov(at)gmail(dot)com> writes:
> Could you kindly explain me why the query as it is updates no records?

It's a bug, that's why. See
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=324577f39bc8738ed0ec24c36c5cb2c2f81ec660
or for 9.2,
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5d545b7ed53a8b2058c1152bd1c9ae227b3280e3

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-12-14 22:42:14 Re: invisible dependencies on a table?
Previous Message Tim Uckun 2013-12-14 21:33:07 Re: invisible dependencies on a table?