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