Urgent! how to delete sequence key from pg_class

From: "Jeff" <jklcom(at)mindspring(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Urgent! how to delete sequence key from pg_class
Date: 2001-03-31 16:57:43
Message-ID: 9a52qt$1obm$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message shawn everett 2001-03-31 17:55:29 Re: Urgent! how to delete sequence key from pg_class
Previous Message Jim Mercer 2001-03-31 15:57:27 Re: pg_hba.conf and crypt/password