On Wed, 22 Feb 2006, Jim C. Nasby wrote:

> On Wed, Feb 22, 2006 at 09:07:29AM -0800, 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.
>
> Any idea why? Being able to detect changes to tables certainly seems
> like a good capability to have, beyond just Slony.

Just to jump in here, but I believe the issue is that you can't put a 
trigger on a system table, which Gavin's patch apparently tries to address 
... if a trigger could be put onto something like pg_class, to detect a 
table being added/removed, then the subsequent transmassion of an 
appropriate CREATE command to the slave(s) wouldn't be too big of an issue 
...