Postgres Pro
Downloads
Home   >   mailing lists

Missing Sequence File - Mailing list pgsql-general

From Killian May
Subject Missing Sequence File
Date
Msg-id Pine.LNX.4.10.10108152340410.3019-100000@infosport.com
Whole thread Raw
In response to RE: Updating a view  ("Ryan C. Bonham" <Ryan@srfarms.com>)
List pgsql-general
Tree view 
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

Thanks in advance,

Killian May
InfoSport Inc
killian.may@infosport.com
(902)423-0662 fax(902)423-0390

pgsql-general by date:

Previous
From: Michael Widenius
Date:
Subject: Re: [Fwd: MySQL Benchmark page - Problem with vacuum() in PostgreSQL]
Next
From: Scott Holmes
Date:
Subject: Re: Syntax for wildcard selection