From: Gregory Wood <gregw@com-stock.com>
To: James Thornton <thornton@cs.baylor.edu>
Cc: PostgreSQL-General <pgsql-general@postgresql.org>
Subject: Re: update returns 1, but no changes have been made
Date: Thu, 6 Dec 2001 13:24:14 -0500
Message-ID: <004301c17e83$365a07d0$7889ffcc@comstock.com> (raw)
References: <3C08A694.86E4153B@cs.baylor.edu>
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@cs.baylor.edu>
To: <pgsql-general@postgresql.org.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@postgresql.org)
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gregw@com-stock.com, thornton@cs.baylor.edu, pgsql-general@postgresql.org
Subject: Re: update returns 1, but no changes have been made
In-Reply-To: <004301c17e83$365a07d0$7889ffcc@comstock.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox