Re: update returns 1, but no changes have been made

Do you perhaps have any triggers or rules on the table in question? If one
of those is intercepting your UPDATE then the changes may not actually get
to the database...

Greg

----- Original Message -----
From: "James Thornton" <thornton(at)cs(dot)baylor(dot)edu>
To: <pgsql-general(at)postgresql(dot)org(dot)pgsql-sql@postgresql.org>
Sent: Saturday, December 01, 2001 4:44 AM
Subject: [GENERAL] update returns 1, but no changes have been made

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>