Thu Nov 6 09:16:17 PST 2008
- Previous message: [Slony1-general] what changes require the use of execute_script
- Next message: [Slony1-general] problem doing failover
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] what changes require the use of execute_script
- Next message: [Slony1-general] problem doing failover
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list