Re: Possible bug in update? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Possible bug in update?
Date
Msg-id 21128.1062044598@sss.pgh.pa.us
Whole thread Raw
In response to Possible bug in update?  (Markus Kräutner <kraeutne@in.tum.de>)
Responses suspicous looking code in copy.c
Re: Possible bug in update?
List pgsql-hackers
Markus Kräutner <kraeutne@in.tum.de> writes:
> At the end of several bulk inserts the following statements get executed:

> begin
> update pom_c2996785 set p3=3268837857008 where p3=34804837857008
> update pom_c2996795 set p3=3268837857008 where p3=34804837857008
> update pom_c2996804 set p3=3268837857008 where p3=34804837857008
> commit

> When I check the database the last update has not been executed. Manually 
> executing it in psql does work.

... ergo, the bug is not in the backend, but in whatever non-psql client
software you are using.  Since you haven't mentioned what that is,
further speculation is difficult ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: paul_tuckfield@yahoo.com (Grant Succeeded)
Date:
Subject: Re: Decent VACUUM (was: Buglist)
Next
From: Tom Lane
Date:
Subject: Re: Decent VACUUM (was: Buglist)