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
>