I've several schemas each one is owned by a user. Then there are websites sharing the same code base using different schemas and connecting with different users. When I have to refactor I generally have to make the same changes for all the schemas. I log in as a user that have enough right to all schemas and apply the changes. Since I've to make all the changes to all schemas I can't apply changes to each schema with different connections. But this ends up in writing a lot of code for altering ownership of objects and eg. turning an int into a serial becomes particularly painful. create sequence alter table ... owner to alter sequence ... owned by ... alter table ... set default ... Is there a less painful approach? -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
