Jeff Frost jeff at frostconsultingllc.com
Thu Nov 6 09:16:17 PST 2008
On Thu, 6 Nov 2008, Geoffrey wrote:

> Can anyone point me to documentation that outlines what changes require the 
> use of 'execute_script?'
>
> For example, I assume it's necessary for:
>
> Adding a new table.
> Adding a new field to an existing table.
> Adding a view.
>
> Is it necessary when:
>
> Adding a new trigger?
> Adding a new function?
>
> Others?

It's not necessary for adding a new table, index, view or function.  You just 
need to make sure you create them on all nodes where they will be used.

You must use it to add a new field to an existing table and to add triggers to 
existing replicated tables.

Check out the documentation here:
http://slony.info/documentation/ddlchanges.html

Especially the section:
15.1. Changes that you might not want to process using EXECUTE SCRIPT

-- 
Jeff Frost, Owner 	<jeff at frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 916-647-6411	FAX: 916-405-4032


More information about the Slony1-general mailing list