cannot delete bug - Mailing list pgsql-sql

From Kemin Zhou
Subject cannot delete bug
Date
Msg-id 3D87A007.9020707@ferring.com
Whole thread Raw
Responses Re: cannot delete bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Returning a reference to a cursor from a function
Next
From: Bruce Momjian
Date:
Subject: Re: How to select and result row number??