pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
cannot delete bug 2+ messages / 2 participants [nested] [flat]
* cannot delete bug @ 2002-09-17 21:35 Kemin Zhou <kemin.zhou@ferring.com> 2002-09-17 22:31 ` Re: cannot delete bug Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Kemin Zhou @ 2002-09-17 21:35 UTC (permalink / raw) To: 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: cannot delete bug 2002-09-17 21:35 cannot delete bug Kemin Zhou <kemin.zhou@ferring.com> @ 2002-09-17 22:31 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2002-09-17 22:31 UTC (permalink / raw) To: Kemin Zhou <kemin.zhou@ferring.com>; +Cc: pgsql-sql 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-09-17 22:31 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-09-17 21:35 cannot delete bug Kemin Zhou <kemin.zhou@ferring.com> 2002-09-17 22:31 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox