What's going on here?

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема What's going on here?
Дата
Msg-id 020501c11603$8f5cef70$8201a8c0@inspiron
обсуждение исходный текст
Ответ на Re: concurent updates  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: What's going on here?
Re: What's going on here?
Re: What's going on here?
Список 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 по дате отправления: