Steve Singer ssinger at ca.afilias.info
Mon May 31 06:54:16 PDT 2010
Steve Singer wrote:
> Lorenzo Bolzani wrote:
>> Hi all,
>> What I'd like slony to do is to handle missing columns (with defaults if 
>> not null), extra columns (ignoring), and for big changes transform data 
>> through a custom script.
>>
>> Can this be achieved?
> 
> I think so, if your careful about the ordering you apply things etc...

I should clarify.

-Extra columns on the replicas are okay
-Extra columns on the origin are NOT okay

DEFAULT values will NOT be filled in on the replicas they columns will 
be left as NULL.





> 
>> It's acceptable, for the most complex cases, to use temporary tables to 
>> save changes to be applied later on the actual ones.
>>
>>
>> Thanks for any pointer
>>
>>
>> Bye
>>
>> Lorenzo
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 


-- 
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142


More information about the Slony1-general mailing list