Craig James craig_james at emolecules.com
Thu Sep 27 07:13:41 PDT 2007
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?

Thanks,
Craig


More information about the Slony1-general mailing list