From: Roy W P. <arc...@mt...> - 2008-03-03 15:58:19
|
The Error... > CREATE SEQUENCE id start 10000, ERROR: relation "id" already exists. can occur when you accidentally restore a Sql-ledger dataset to the template1 database. template1 is used as a starting point every time a new database is created. Therefore, if you accidentally create/restore a sql-ledger dataset into template1, the id table is created in the template1 database and every single database thereafter. Hope that makes sense. Roy |