Hi steve, Your command should be like: iosdb=>drop sequence "classtable serials"; Use the real name of the sequence, you cannot use serial to imply your sequence name. Your sequence seems having space. this is why you need to use the double quotation. Your can name your sequence like classtable_serials, later if you want to drop, can use drop sequence classtable_serials; -- banghe steve doerr wrote: > bangh wrote: > > > You mean a sequence? If so, under psql use command:\z to check the sequence > > name (it is stored in the table), then use the command drop sequence > > sequence_name > > Thanks Banghe, here's what's there: > > iosdb=> \z > Database = iosdb > +-------------+--------------------------+ > | Relation | Grant/Revoke Permissions | > +-------------+--------------------------+ > | classtables | | > | serials | | > +-------------+--------------------------+ > > I did the command "drop sequence serials" in the database, but the "\z" shows > the same thing after that. > > When I run a shell script that's supposed to dump and recreate the db and user > w/ java I get: > > Trace: > java.sql.SQLException: ERROR: Relation 'serials' already exists > > Is that how you're supposed to clear out the serials relation? > > Thanks for the input, > Steve
