Re: drop table bug and how to recover?

From: Myra Chachkin <myra(at)ack(dot)Berkeley(dot)EDU>
To: elein(at)varlena(dot)com, sfpug(at)postgresql(dot)org
Subject: Re: drop table bug and how to recover?
Date: 2004-09-08 17:14:20
Message-ID: 20040908101420.H16403@ack.Berkeley.EDU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

Hi Elein,

It's very possible that an error slipped by me. :-(

I did try \d, and got "did not find any relation". And I
get 0 rows when I try the relname query.

Thanks,
Myra

On Wed, Sep 08, 2004 at 10:03:11AM -0700, elein wrote:
> 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

In response to

Browse sfpug by date

  From Date Subject
Next Message Josh Berkus 2004-09-08 17:18:47 Re: drop table bug and how to recover?
Previous Message Myra Chachkin 2004-09-08 17:10:44 Re: drop table bug and how to recover?