Some days ago I asked regarding tables located in different schemas. Now, my question is Suppose I have two schemas (other than public): "qa" and "production". Initially I create all my tables in "qa". All of them have a primary key of type serial. Later, I will copy the tables definitions to production. It will automatically create the sequences in the new schema, starting at zero? TIA Marcelo
Marcelo, >Initially I create all my tables in "qa". All of them have a primary key of type serial. >Later, I will copy the tables definitions to production.
A word of caution, creating tables in a qa "schema" and then transferring to production is not the normal/correct (or safe) way to do development.
The standard procedure is to create a seperate "qa" database (and/or server) with the exact same schema(s) as production. Then, after testing
is completed, the schemas/tables are copied to production.
This. Staging should look as much like production as possible for testing purposes. If you HAVE to use the same server (not a good idea) then make separate clusters. Separate servers here can save you a LOT of heartache from someone fat fingering a script meant for staging hitting production.