Обсуждение: BUG #13429: Update 0 rows for matching record

Поиск
Список
Период
Сортировка

BUG #13429: Update 0 rows for matching record

От
smoola@travelclick.com
Дата:
The following bug has been logged on the website:

Bug reference:      13429
Logged by:          Sandeep Moola
Email address:      smoola@travelclick.com
PostgreSQL version: 9.2.8
Operating system:   Red Hat Enterprise Linux Server release 6.5
Description:

We were trying to update a record in our database as below and the row was
not getting updated. No error was shown neither on the command promt nor in
the logs
STEP1:
SELECT yrd_cuttoff FROM yrd_yield_room_details WHERE
yrd_yrd_key=10060451491;
 yrd_cuttoff
-------------
 N
(1 row)

STEP2:
UPDATE yrd_yield_room_details SET yrd_cuttoff='NC' WHERE
yrd_yrd_key=10060451491;
UPDATE 0

STEP3:
SELECT yrd_cuttoff FROM yrd_yield_room_details WHERE
yrd_yrd_key=10060451491;
 yrd_cuttoff
-------------
 N

Re: BUG #13429: Update 0 rows for matching record

От
"David G. Johnston"
Дата:
On Wed, Jun 10, 2015 at 12:19 PM, <smoola@travelclick.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      13429
> Logged by:          Sandeep Moola
> Email address:      smoola@travelclick.com
> PostgreSQL version: 9.2.8
> Operating system:   Red Hat Enterprise Linux Server release 6.5
> Description:
>
> We were trying to update a record in our database as below and the row wa=
s
> not getting updated. No error was shown neither on the command promt nor =
in
> the logs
> STEP1:
> SELECT yrd_cuttoff FROM yrd_yield_room_details WHERE
> yrd_yrd_key=3D10060451491;
>  yrd_cuttoff
> -------------
>  N
> (1 row)
>
> STEP2:
> UPDATE yrd_yield_room_details SET yrd_cuttoff=3D'NC' WHERE
> yrd_yrd_key=3D10060451491;
> UPDATE 0
>
> STEP3:
> SELECT yrd_cuttoff FROM yrd_yield_room_details WHERE
> yrd_yrd_key=3D10060451491;
>  yrd_cuttoff
> -------------
>  N
>
>
=E2=80=8BThis is not likely to be a bug but in any case if you are not able=
 to
supply a self-contained test case, or the actual schema involved, figuring
out where you likely have a problem is going to be difficult.

As a first stab: are there any triggers on "yrd_yield_room_details"?

=E2=80=8BDavid J.=E2=80=8B