On Thursday 27 September 2007 07:13:41 Craig James wrote:
> Suppose I have two tables, SOURCE and DESTINATION, and only DESTINATION is
> under Slony replication.  Does the following work?
>
>    insert into DESTINATION(a,b,c) (select a,b,c from SOURCE);
>
> Since the slave database doesn't have the SOURCE table, how will Slony get
> the data?  Does it convert it into a series of one-line inserts?  Does it
> just fail in this case?

Slony is not statement replication so yes this will work fine, internaly it 
will be converted to a series of one line inserts, which will all be applied 
to the subscriber in a single transaction.


>
> Thanks,
> Craig
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general