Re: Possible bug in update?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kraeutne(at)in(dot)tum(dot)de
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Possible bug in update?
Date: 2003-08-28 04:23:18
Message-ID: 21128.1062044598@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Markus =?iso-8859-15?q?Kr=E4utner?= <kraeutne(at)in(dot)tum(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-08-28 04:39:56 Re: Decent VACUUM (was: Buglist)
Previous Message Jim Mercer 2003-08-28 04:21:58 Re: Possible bug in update?