http://www.slony.info/bugzilla/show_bug.cgi?id=33

           Summary: Slonik-execute-script fails if cluster name has a "-"
           Product: Slony-I
           Version: 1.2
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: medium
         Component: slonik
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: nikeow at yahoo.com
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


I wanted to do some DDL changes to an existing replicated table per the below
link example.
http://www.onlamp.com/pub/a/onlamp/2005/03/17/slony_changes.html?page=last

my clustername was not sane and uses a hypen "-"

The script will fail because of that (I think)

#!/bin/sh

#
# Create a new column in a table in the replicated set
#
echo "Creating new column in the whatever table"
slonik <<_EOF_
cluster name = test-db;
node 1 admin conninfo = 'dbname=hmxmms host=192.168.10.100 user=postgres
port=5432';
node 2 admin conninfo = 'dbname=hmxmms host=192.168.10.20  user=postgres
port=5432';

execute script ( SET ID = 1, FILENAME =
'/home/gentoo/Desktop/postgres_loading/slony_add_column.sql', EVENT NODE = 1);
_EOF_

I've tried to quote it, double quote it and to escape it w/o success.

Finally, I created another cluster named "test" and it worked fine.


-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.