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
