Thread: Urgent! how to delete sequence key from pg_class

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

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
>