Re: [SQL] cannot delete bug

2002-09-17 Thread Tom Lane
Kemin Zhou <[EMAIL PROTECTED]> 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?

[SQL] cannot delete bug

2002-09-17 Thread Kemin Zhou
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 ta