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

Re: drop table bug and how to recover?

From: Myra Chachkin <myra(at)ack(dot)Berkeley(dot)EDU>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: sfpug(at)postgresql(dot)org
Subject: Re: drop table bug and how to recover?
Date: 2004-09-08 18:49:20
Message-ID: 20040908114920.M16403@ack.Berkeley.EDU (view raw or flat)
Thread:
Lists: sfpug
Hi Josh,

I can't create the table, Postgres still thinks it exists.  And I can't 
drop it either.

Maybe I was unclear about recreating the error.  I don't have my screen
buffer of what happened the first time I tried this.  But the problem of
not being able to drop or recreate the table is extremely repeatable. 
I'd like to find a way to recover from this situation so that I can use 
the tablename.

Thanks,
Myra


On Wed, Sep 08, 2004 at 10:38:58AM -0700, Josh Berkus wrote:
> Myra,
> 
> > Well, I need that specific tablename...sigh.
> 
> I don't understand.   If you can't repeat the error, what's stopping you from 
> creating the table?
> 
> -- 
> Josh Berkus
> Aglio Database Solutions
> San Francisco

In response to

Responses

sfpug by date

Next:From: Josh BerkusDate: 2004-09-08 18:55:42
Subject: Re: drop table bug and how to recover?
Previous:From: Josh BerkusDate: 2004-09-08 17:38:58
Subject: Re: drop table bug and how to recover?

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