On Mon, 20 Aug 2001 18:19:49 +0000 (UTC), Killian May <[EMAIL PROTECTED]>: > 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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])