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

           Summary: create set is not well parsed
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: minor
          Priority: low
         Component: slonik
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: cedric.villemain.debian at gmail.com
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


you can use a "create set (origin = 1)" and it is not refuse by slonik but it
won't work:

 /usr/lib/postgresql/9.1/bin/slonik < create_set.slonik
<stdin>:4: PGRES_FATAL_ERROR select set_origin from "_slony"."sl_set" where
set_id=1 - ERREUR:  le schéma « _slony » n'existe pas
LINE 1: select set_origin from "_slony"."sl_set" where set_id=1
                               ^
<stdin>:4: PGRES_FATAL_ERROR select set_origin from "_slony"."sl_set" where
set_id=1 - ERREUR:  le schéma « _slony » n'existe pas
LINE 1: select set_origin from "_slony"."sl_set" where set_id=1
                               ^
<stdin>:4: PGRES_FATAL_ERROR select set_origin from "_slony"."sl_set" where
set_id=1 - ERREUR:  le schéma « _slony » n'existe pas
LINE 1: select set_origin from "_slony"."sl_set" where set_id=1
                               ^
<stdin>:4: warning: could not query node 2 for origin<stdin>:4: warning: could
not query node 3 for origin<stdin>:4: warning: could not query node 4 for
origin<stdin>:4:Error: unable to determine the origin for set 1

preamble.slonik:
    cluster name = slony;
    node 1 admin conninfo = 'dbname=slony_bench host=192.168.100.165
user=replicator';
    node 2 admin conninfo = 'dbname=slony_bench host=192.168.100.237
user=replicator';
    node 3 admin conninfo = 'dbname=slony_bench host=192.168.122.111
user=replicator';
    node 4 admin conninfo = 'dbname=slony_bench host=192.168.122.22
user=replicator';

create_set.slonik:
include </tmp/preamble.slonik>;
init cluster (id = 1);
create set (origin = 1);
set add table (set id=1, tables='public\\.*');

store node (id=2, event node=1);
store node (id=3, event node=1);
store node (id=4, event node=2);

store path (server = 1, client = 2, conninfo='dbname=slony_bench
host=192.168.100.165 user=replicator');
store path (server = 1, client = 3, conninfo='dbname=slony_bench
host=192.168.100.165 user=replicator');
store path (server = 1, client = 4, conninfo='dbname=slony_bench
host=192.168.100.165 user=replicator');

store path (server = 2, client = 1, conninfo='dbname=slony_bench
host=192.168.100.237 user=replicator');
store path (server = 2, client = 3, conninfo='dbname=slony_bench
host=192.168.100.237 user=replicator');
store path (server = 2, client = 4, conninfo='dbname=slony_bench
host=192.168.100.237 user=replicator');

store path (server = 3, client = 1, conninfo='dbname=slony_bench
host=192.168.122.111 user=replicator');
store path (server = 3, client = 2, conninfo='dbname=slony_bench
host=192.168.122.111 user=replicator');
store path (server = 3, client = 4, conninfo='dbname=slony_bench
host=192.168.122.111 user=replicator');

store path (server = 4, client = 1, conninfo='dbname=slony_bench
host=192.168.122.22 user=replicator');
store path (server = 4, client = 2, conninfo='dbname=slony_bench
host=192.168.122.22 user=replicator');
store path (server = 4, client = 3, conninfo='dbname=slony_bench
host=192.168.122.22 user=replicator');

-- 
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.