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 <melvin6925 at yahoo.com>
> 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.