Thread: cannot delete bug
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.
Kemin Zhou <kemin.zhou@ferring.com> writes: > 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 Have you got any rules, triggers, or foreign keys linking to or from that table? regards, tom lane