From: Kemin Zhou <kemin.zhou@ferring.com>
To: pgsql-sql@postgresql.org
Subject: cannot delete bug
Date: Tue, 17 Sep 2002 14:35:03 -0700
Message-ID: <3D87A007.9020707@ferring.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: kemin.zhou@ferring.com
Subject: Re: cannot delete bug
In-Reply-To: <3D87A007.9020707@ferring.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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