Urgent! how to delete sequence key from pg_class
Started by Jeff Luabout 25 years ago2 messagesgeneral
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
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?