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: 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 (view raw or flat)
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

sfpug by date

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

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