Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 65113476072 for ; Tue, 17 Sep 2002 17:35:00 -0400 (EDT) Received: from fedk0905.FERRING.COM (fedk0905.ferring.com [213.237.141.20]) by postgresql.org (Postfix) with ESMTP id 4D082475F26 for ; Tue, 17 Sep 2002 17:34:59 -0400 (EDT) Received: from fedk0005.Fic.ferring.com (unverified) by fedk0905.FERRING.COM (Content Technologies SMTPRS 4.2.1) with ESMTP id for ; Tue, 17 Sep 2002 23:34:58 +0200 Received: from ferring.com (10.20.100.63 [10.20.100.63]) by fedk0005.Fic.ferring.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id TB8RVPPX; Tue, 17 Sep 2002 23:34:58 +0200 Message-ID: <3D87A007.9020707@ferring.com> Date: Tue, 17 Sep 2002 14:35:03 -0700 From: Kemin Zhou User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.1b) Gecko/20020722 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: cannot delete bug Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/196 X-Sequence-Number: 9473 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.