From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Dave Cramer <Dave(at)micro-automation(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: What's going on here? |
Date: | 2001-07-26 19:21:54 |
Message-ID: | Pine.BSF.4.21.0107261220530.77833-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | J.H.M. Dassen Ray | 2001-07-26 19:24:20 | Re: What's going on here? |
Previous Message | Dave Cramer | 2001-07-26 18:48:28 | What's going on here? |