Re: Missing Sequence File

On Mon, 20 Aug 2001 18:19:49 +0000 (UTC), Killian May <kmay(at)infosport(dot)com>:
> Hi,
>
> I'm a little new to postgres, and I'm having trouble droping a sequence.
> I get the following error:
>
> ERROR: mdopen: couldn't open scotty_scottyid_seq: No such file or
> directory
>
> when I try to recreate the sequence I get the following:
>
> gsheet=> create sequence scotty_scottyid_seq;
> ERROR: Relation 'scotty_scottyid_seq' already exists
>

Which version are you running?
select version();
should give a precise answer.

Show the command you are using to drop the sequence
like you do here for creating the sequence.

Can you get values from the sequence?
select nextval('scotty_scottyid_seq')
and show the output.