Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff
Subject Urgent! how to delete sequence key from pg_class
Date
Msg-id 9a52qt$1obm$1@news.tht.net
Whole thread Raw
Responses Re: Urgent! how to delete sequence key from pg_class  (shawn everett <everett@pgweb.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jim Mercer
Date:
Subject: Re: pg_hba.conf and crypt/password
Next
From: shawn everett
Date:
Subject: Re: Urgent! how to delete sequence key from pg_class