Received: from mail.com-stock.com (mail.com-stock.com [204.255.137.254]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB6IMKm78069 for ; Thu, 6 Dec 2001 13:22:33 -0500 (EST) (envelope-from gregw@com-stock.com) Received: by mail.com-stock.com (Postfix, from userid 1000) id 7E274101; Thu, 6 Dec 2001 13:22:40 -0500 (EST) Received: from deimos (deimos.com-stock.com [204.255.137.120]) by mail.com-stock.com (Postfix) with SMTP id 47AE2D9EE; Thu, 6 Dec 2001 13:22:38 -0500 (EST) Message-ID: <004301c17e83$365a07d0$7889ffcc@comstock.com> From: "Gregory Wood" To: "James Thornton" Cc: "PostgreSQL-General" References: <3C08A694.86E4153B@cs.baylor.edu> Subject: Re: update returns 1, but no changes have been made Date: Thu, 6 Dec 2001 13:24:14 -0500 Organization: Comstock Net Services MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-Mimeole: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Archive-Number: 200112/166 X-Sequence-Number: 18270 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" To: 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) >