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
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? |