I beg to disagree with those who say you MUST or even SHOULD use execute script to create a table with a foreign key to a replicated table. In the same way that I can drop or add a key to a replicated table directly on the slave, I would not expect Slony to care about the new foreign key reference. Can anyone say what bad things might happen of which I am unaware?
Vivek Khera wrote: > > On Mon, Oct 5, 2009 at 11:07 AM, Melvin Davidson <[email protected]> > wrote: >>>Does that create table command need to be run via EXECUTE SCRIPT in slony1? >> >> Yes. Whenever you create or modify objects, you should always use EXECUTE >> SCRIPT. >> Doing so insures that the changes are propagated across all nodes. > -- View this message in context: http://www.nabble.com/when-creating-new-table-with-FK-reference-to-existing-replicated-table%2C-do-I-need-to-run-via-EXECUTE-SCRIPT--tp25752443p25755920.html Sent from the Slony-I -- General mailing list archive at Nabble.com. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
