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 20:51:22
Message-ID: 20040908135122.B27070@ack.Berkeley.EDU (view raw or flat)
Thread:
Lists: sfpug
Hi all,

Thanks for all your help, I really appreciate it.  

I've found my problem (d'oh!)  The fear of displaying my broken sql 
caused me to look it over extra-carefully and find the error that I 
hadn't spotted before.  For the record, I had typo'd the table constraint 
name to be the same as the table name, causing the "relation already 
exists" error.  No bug, just PEBCAK.

Myra

On Wed, Sep 08, 2004 at 11:55:42AM -0700, Josh Berkus wrote:
> If you can repeat it, please paste it here.  Preferably both drop and create 
> statements.

In response to

Responses

sfpug by date

Next:From: Josh BerkusDate: 2004-09-08 20:53:56
Subject: Re: drop table bug and how to recover?
Previous:From: Josh BerkusDate: 2004-09-08 18:55:42
Subject: Re: drop table bug and how to recover?

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