Andrew Sullivan wrote:
> On Mon, Apr 05, 2004 at 10:15:23AM +0100, Richard Frith-Macdonald wrote:
>> Is there support or this already present which I've missed in looking 
>> at the source code?  If so, where should I look?
> 
> No, not yet.
> 
>> If not how is the process to 'execute SQL scripts in a controlled 
>> fashion' intended to work?
> 
> The trick will be to ensure that DDL gets processed at the right
> logical time.  I believe this code is high on Jan's current TODO
> list, but I don't think the details are done yet.  It almost
> certainly will not be transparent, however.

The details are not done yet. My current priority list is

   1. Failover
   2. DDL Scripts
   3. Explicit excluded triggers

Point 3 is an additional requirement that came up last week and simply 
means another config table to tell Slony to keep it's fingers off of 
certain triggers.

The DDL script support means that one cannot just hack in another ALTER 
TABLE into the production system any more. Instead the commands have to 
be put into a file and that executed via the slonik command line utility 
against the master database. That way, the replication system knows 
exactly when to execute the same commands on the slaves.

The timeframe to implement all 3 is 4 weeks at the max. Then I will 
freeze the features and go into BETA for a first release.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #