Re: Missing Sequence File

On Mon, 20 Aug 2001 18:19:49 +0000 (UTC), Killian May <kmay@infosport.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.