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