Re: Urgent! how to delete sequence key from pg_class - Mailing list pgsql-general

From shawn everett
Subject Re: Urgent! how to delete sequence key from pg_class
Date
Msg-id Pine.LNX.4.30.0103310955090.30435-100000@alder.pgweb.com
Whole thread Raw
In response to Urgent! how to delete sequence key from pg_class  ("Jeff" <jklcom@mindspring.com>)
List pgsql-general
Have you tried drop sequence?

On Sat, 31 Mar 2001, Jeff wrote:

> Hi,
>
> I've accidently deleted the file employees.key.seq, however there's still an
> entry in pg_class.
>
> It would not allow me to create employees.key.seq anymore because it thinks
> it already exists.
>
> How can I delete it from pg_class?
>
> Thanks
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>


pgsql-general by date:

Previous
From: "Jeff"
Date:
Subject: Urgent! how to delete sequence key from pg_class
Next
From: Lincoln Yeoh
Date:
Subject: Re: Q: Record Updating/Locking in Web Environments