Thanks for the info - I'm sure it would be useful to have this added to 
the docs, it's bound to crop up again.

John Sidney-Woollett

cbbrowne at ca.afilias.info wrote:

>>I need to update two functions within our master database that is
>>replicated to a slave using Slony. The updated functions are needed on
>>both the master and slave. It's needed on the slave in case we have to
>>failover to it...
>>
>>Can I safely apply the new functions scripts (pl/pgsql) to both the
>>slave and master (ignoring the fact that slony is installed)? Or do I
>>have to use the slony EXECUTE SCRIPT command for this? No table or data
>>changes are required.
>>
>>I just wanted to check before I screw up the cluster!
> 
> 
> No, that won't mess anything up.
> 
> Similarly, creating extra indices could be done (and probably should be)
> without resorting to EXECUTE SCRIPT.
> 
> There points to some more docs that need to be...
>