On Jan 27, 2005, at 10:11 AM, Steve Simms wrote:
> Creating/dropping indexes, provided they're not primary keys or 
> otherwise being used for replication, can be done on each server 
> without going through the EXECUTE SCRIPT command.

Thanks, I'll give this a try.   I was under the impression all DDL 
changes should go through execute script.   Is there some sort of list 
of safe commands that can be done outside of slony?   How about adding 
foreign keys?

http://cbbrowne.com/info/ddlchanges.html and 
http://cbbrowne.com/info/stmtddlscript.html don't seem to get into 
this.

> I can't help you with the overall problem, though -- I look forward to 
> seeing the responses from more knowledgeable people, as this would 
> have a definite impact in my environment as well.
>

Me too. Your advice will help with some of the easier tasks we have, 
but i'll have to wait to hear what to do about the more complex DDL 
changes.

--------------------------------------------
MobyGames
http://www.mobygames.com
The world's largest and most comprehensive?
gaming database project