What's going on here? - Mailing list pgsql-general

From Dave Cramer
Subject What's going on here?
Date
Msg-id 020501c11603$8f5cef70$8201a8c0@inspiron
Whole thread Raw
In response to Re: concurent updates  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: What's going on here?
Re: What's going on here?
Re: What's going on here?
List pgsql-general

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


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: concurent updates
Next
From: Stephan Szabo
Date:
Subject: Re: What's going on here?