Skip site navigation (1) Skip section navigation (2)

Re: Urgent! how to delete sequence key from pg_class

From: shawn everett <everett(at)pgweb(dot)com>
To: Jeff <jklcom(at)mindspring(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Urgent! how to delete sequence key from pg_class
Date: 2001-03-31 17:55:29
Message-ID: Pine.LNX.4.30.0103310955090.30435-100000@alder.pgweb.com (view raw or flat)
Thread:
Lists: 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
>


In response to

pgsql-general by date

Next:From: Steve ArasDate: 2001-03-31 18:31:51
Subject: where does the -i go?
Previous:From: JeffDate: 2001-03-31 16:57:43
Subject: Urgent! how to delete sequence key from pg_class

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