Postgres Pro
Downloads
Home   >   mailing lists

update returns 1, but no changes have been made - Mailing list pgsql-hackers

From James Thornton
Subject update returns 1, but no changes have been made
Date
Msg-id 3C0A7394.B148B9F1@cs.baylor.edu
Whole thread Raw
List pgsql-hackers
Tree view 
I have been trying to update a table -- the update statement returns 1
indicating that one row has been updated, but no changes were made. 

This is happening on two servers: 
      1.my development server, running Postgres 7.0.3, RedHat 7.1       2.soon-to-be production server running Postgres
7.1.3,RedHat 6.2 
 

Could I have a deadlock? Something else?  

What should I be looking for?

Thanks.
JT
________________________________________
James Thornton, http://jamesthornton.com

pgsql-hackers by date:

Previous
From: mkscott@sacadia.com
Date:
Subject: Using Threads (again)
Next
From: Jan Wieck
Date:
Subject: Profiling under Linux