David Fetter david at fetter.org
Fri Mar 16 05:56:46 PDT 2007
Folks,

When managing database changes on a single database, I frequently do
things like:

BEGIN;
CREATE TABLE ...;
COPY ... ; -- Populate the new table
ALTER TABLE ... ADD COLUMN ... USING ... ; -- From previous statements
ALTER TABLE ...;
DROP TABLE ....;
...
COMMIT;

This way, only whole schema changes are visible.

How do people approach this with Slony?

Cheers,
D
-- 
David Fetter <david at fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate


More information about the Slony1-general mailing list