cannot delete bug

Поиск
Список
Период
Сортировка
От Kemin Zhou
Тема cannot delete bug
Дата
Msg-id 3D87A007.9020707@ferring.com
обсуждение исходный текст
Ответы Re: cannot delete bug
Список pgsql-sql
Dear Friends,
I am not sure this due to my hardware problem or due to a bug in
the postgres 7.2.

kzdb=# select id from mytable where id=7224; id 
------7224
(1 row)

kzdb=# delete from mytable where id=7224;
ERROR:  Relation 41073353 does not exist
kzdb=#

My simple solution is to dump the table as text
then \copy back in the table again after dropping
the old table.  This had repeatly happend to me.
I guess there is something very wrong somewhere,
bug I don't know.

If any one has any experience please let me know.
Apprciate.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Returning a reference to a cursor from a function
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: How to select and result row number??