update returns 1, but no changes have been made

From: James Thornton <thornton(at)cs(dot)baylor(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: update returns 1, but no changes have been made
Date: 2001-12-02 18:31:48
Message-ID: 3C0A7394.B148B9F1@cs.baylor.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-12-03 01:01:14 Re: configuration files and PGDATA variable
Previous Message mlw 2001-12-02 16:04:36 configuration files and PGDATA variable