Received: from megazone23.bigpanda.com ([216.136.151.41])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f6QJLvf81091
	for <pgsql-general@postgresql.org>;
	Thu, 26 Jul 2001 15:21:58 -0400 (EDT)
	(envelope-from sszabo@megazone23.bigpanda.com)
Received: from localhost (sszabo@localhost)
	by megazone23.bigpanda.com (8.11.2/8.11.2) with ESMTP id f6QJLsZ77843;
	Thu, 26 Jul 2001 12:21:55 -0700 (PDT)
Date: Thu, 26 Jul 2001 12:21:54 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Dave Cramer <Dave@micro-automation.net>
cc: pgsql-general@postgresql.org
Subject: Re: What's going on here?
In-Reply-To: <020501c11603$8f5cef70$8201a8c0@inspiron>
Message-ID: <Pine.BSF.4.21.0107261220530.77833-100000@megazone23.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200107/947
X-Sequence-Number: 13067

On Thu, 26 Jul 2001, Dave Cramer wrote:

> 
> 
> 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

Hmm, could it perhaps be a view (rather than a table)?  If it is a table,
are there any views or triggers on the table that might be interfering
with the update?