Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB3Id0m12240; Mon, 3 Dec 2001 13:39:00 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fB3IE4O71034; Mon, 3 Dec 2001 13:14:04 -0500 (EST) (envelope-from news) From: James Thornton X-Newsgroups: comp.databases.postgresql.sql, comp.databases.postgresql.questions Subject: update returns 1, but no changes have been made Date: Sat, 01 Dec 2001 03:44:52 -0600 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 17 Message-ID: <3C08A694.86E4153B@cs.baylor.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.76C-SGI [en] (X11; I; IRIX 6.5 IP32) X-Accept-Language: en To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200112/150 X-Sequence-Number: 18254 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