Urgent! how to delete sequence key from pg_class

Started by Jeff Luabout 25 years ago2 messagesgeneral
Jump to latest
#1Jeff Lu
jklcom@mindspring.com

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

#2shawn everett
everett@pgweb.com
In reply to: Jeff Lu (#1)
Re: Urgent! how to delete sequence key from pg_class

Have you tried drop sequence?

On Sat, 31 Mar 2001, Jeff wrote:

Show quoted text

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