Skip site navigation (1) Skip section navigation (2)

Re: drop table bug and how to recover?

From: elein <elein(at)varlena(dot)com>
To: Myra Chachkin <myra(at)ack(dot)Berkeley(dot)EDU>
Cc: sfpug(at)postgresql(dot)org
Subject: Re: drop table bug and how to recover?
Date: 2004-09-08 17:03:11
Message-ID: 20040908100311.O11707@cookie.varlena.com (view raw or flat)
Thread:
Lists: sfpug
After you drop the table, did you get any warning or
error?  And then did you check to see if the table
actually existed after dropping it?  Try \d in psql
*and* try:
	select relname from pg_class where relname='mytable';

I suspect an error slipped by without your notice.

elein

On Wed, Sep 08, 2004 at 09:58:53AM -0700, Myra Chachkin wrote:
> Hi sfpug folks,
> 
> We're running postgres 7.4.1.  I think I may have hit a drop table
> bug?  I created a table, then dropped it, but now get "relation
> already exists" when I try to recreate it.  There wasn't anything
> weird about the table AFAIK, except that the rowid was defined with 
> a default nextval of another table's sequence (hence my drop).  I 
> did this directly in the SQL monitor.
> 
> I found a few old postings from v.6.5.2 about problems dropping and
> recreating a table, either because of the "int8" type, or when 
> dropping within a transaction and then rolling back.  The int8 
> problem was supposedly fixed upon quitting and re-entering psql.
> That doesn't work for me.  The transaction problem was supposedly 
> fixed upon going to the /data/base/database directory, creating
> empty files, and then dropping the table for real.  I would try
> this, but I'm not sure what to create in my /data/base directory; it 
> contains a bunch of numeric subdirectories that don't mean much to me.
> 
> Thanks for any advice!
> 
> Myra

In response to

Responses

sfpug by date

Next:From: Myra ChachkinDate: 2004-09-08 17:10:44
Subject: Re: drop table bug and how to recover?
Previous:From: Josh BerkusDate: 2004-09-08 17:00:12
Subject: Re: drop table bug and how to recover?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group