Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6QIp9f68142 for ; Thu, 26 Jul 2001 14:51:09 -0400 (EDT) (envelope-from Dave@micro-automation.net) Received: (qmail 29025 invoked from network); 26 Jul 2001 18:51:07 -0000 Received: from eboxwest.ebox.com (HELO inspiron) (206.51.23.194) by net2.micro-automation.com with SMTP; 26 Jul 2001 18:51:07 -0000 Reply-To: From: "Dave Cramer" To: Subject: What's going on here? Date: Thu, 26 Jul 2001 14:48:28 -0400 Organization: Micro Automation Inc. Message-ID: <020501c11603$8f5cef70$8201a8c0@inspiron> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 In-reply-to: X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Importance: Normal X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) X-Archive-Number: 200107/946 X-Sequence-Number: 13066 I can't seem to change any rows in this table. Are there locks somewhere that I can look at or fix ebox=# select version(); version ------------------------------------------------------------- PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96 (1 row) ebox=# select eitemcode,itemavail from inventory where itemavail = 1 limit 1; eitemcode | itemavail -----------+----------- 6100122 | 1 (1 row) ebox=# update inventory set itemavail=0 where eitemcode=6100122; UPDATE 0 Thanks in advance, Dave