Mark Hagger wrote:
> Hi,
>
> We're running slony 1.2.15 and I've run into a bit of a problem.  I 
> was trying to do a "move set" on a replication cluster, but it seems 
> that since
> the cluster name has a hyphen in it I have a bit of a problem.  
> Basically I'm running this:
>
> slonik <<_EOF_
>         cluster name = GB-LDC;
>
>         node 1 admin conninfo = 'dbname=$DBNAME port=5433 
> host=$MASTERHOST user=$REPLICATIONUSER';
>         node 2 admin conninfo = 'dbname=$DBNAME port=5433 
> host=$WORKHOST user=$REPLICATIONUSER';
>
>         lock set (id = 1, origin = 1);
>         wait for event (origin = 1, confirmed = 2);
>         move set (id = 1, old origin = 1, new origin = 2);
>         wait for event (origin = 1, confirmed = 2);
>
> _EOF_
>
> But it fails on the "cluster name = " bit, with a:
>
> <stdin>:1: ERROR: syntax error at or near -
>
> The same sort of thing has worked fine on most of the other clusters, 
> but those have a simple alphanumeric name.
>
> I've tried various attempts at quoting the cluster name, but nothing 
> seems to be making any difference.  I fear that I've just made a 
> fundamental mistake in having a hyphen in the name and have no choice 
> but to try and drop the clusters and re-create them, but I'm hopeful 
> that someone has a cunning plan....
>
I'm surprised you got far enough to be able to consider a MOVE SET request.

The cluster name is handled by Slonik as an alphanumeric string, in much 
the same form as a SQL identifier, and it does not support quoting.

It's conceivable that you might try running, on each node:

  alter schema "_GB-LDC" rename to "_GB_LDC";

I'd suggest trying that out in a test environment first :-)

-- 
output = ("cbbrowne" "@" "ca.afilias.info")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"