Wed Feb 22 09:30:53 PST 2006
- Previous message: [Slony1-general] DDL replication (contuned) ...
- Next message: [Slony1-general] DDL replication (contuned) ...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Wednesday 22 February 2006 09:15, Marc G. Fournier wrote: > On Wed, 22 Feb 2006, Darcy Buskermolen wrote: > > On Wednesday 22 February 2006 09:07, Darcy Buskermolen wrote: > >> On Wednesday 22 February 2006 08:48, Marc G. Fournier wrote: > >>> Is there any work being done on Slony-I replicating DDL's? And, of > >>> course, setting up replication on any TABLES created in the process? > >> > >> No there is not any work on this.. in order to support this it would > >> require hacks to the PG backend.. This could probably be done with > >> Gavin's system table trigger patches. The patches were never accepted > >> for inclusion by core. > > > > Having said this, DDL can be mannaged through execute script. > > http://www.dbitech.ca/slony/book/stmtddlscript.html > > In the case where I'm looking to need this, the application is creating > tables on the fly, and no two tables necessarily have the same schema ... > don't ask, not my design, just having to support it :( You might be able to fake it and add some custom hooks to pg_pool to manage all of this for you, though I'm resistant to that idea.. You may need to sell them on mammoth replicator, or else talk to swm and see how possible his patchset is to so what's needed :/ > _______________________________________________ > Slony1-general mailing list > Slony1-general at gborg.postgresql.org > http://gborg.postgresql.org/mailman/listinfo/slony1-general -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759
- Previous message: [Slony1-general] DDL replication (contuned) ...
- Next message: [Slony1-general] DDL replication (contuned) ...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list