Re: Possible bug in update?

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