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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse sfpug by date

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