On Fri, 2007-01-26 at 10:13 -0500, Andrew Sullivan wrote:
> On Fri, Jan 26, 2007 at 09:55:55AM -0500, Sven Willenberger wrote:
> > 
> > Now there is a [tablename] on B and C to which I added a column and then
> > subsequently created a default value for.
> 
> How did you do this?
> 
> A
> 

If you are asking what the actual ddl script contained, it goes as
follows:
# cat ddlscript.sql
ALTER TABLE customer ADD billed BOOL;
ALTER TABLE customer ALTER billed SET DEFAULT false;

# cat slony_execute_script.sh
#!/usr/local/bin/bash

slonik <<_EOF_ 2>> /usr/local/etc/slony/slony_setup.log 1>> /usr/local/etc/slony/slony_setup.log
        cluster name = T2;
        node 1 admin conninfo = 'dbname=dbA host=ipA port=5432 user=slony password=****';
        node 2 admin conninfo = 'dbname=dbB host=ipB port=5432 user=slony password=****';
        node 3 admin conninfo = 'dbname=dbC host=ipC port=5432 user=slony password=****';

        try {
                EXECUTE SCRIPT ( SET ID = 2, FILENAME = 'ddlscript.sql', EVENT NODE = 2);
        }
        on error {
                echo 'Failed to execute script';
                exit -1;
        }
_EOF_

As I have stated the changes were properly executed by the script on the
target tables, but the changes were attempted on the node that was not
part of this set.

Sven