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       <[EMAIL PROTECTED]>
Frost Consulting, LLC   http://www.frostconsultingllc.com/
Phone: 916-647-6411     FAX: 916-405-4032
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to