Skip site navigation (1) Skip section navigation (2)

What's going on here?

From: "Dave Cramer" <Dave(at)micro-automation(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: What's going on here?
Date: 2001-07-26 18:48:28
Message-ID: 020501c11603$8f5cef70$8201a8c0@inspiron (view raw, whole thread or download thread mbox)
Lists: 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();
 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;

Thanks in advance,


In response to


pgsql-general by date

Next:From: Stephan SzaboDate: 2001-07-26 19:21:54
Subject: Re: What's going on here?
Previous:From: Stephan SzaboDate: 2001-07-26 18:00:34
Subject: Re: concurent updates

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group