Hello guys!

I'm trying to initialise the cluster and get the following error:

[17:49] u0235:slony-I# slonik < slonik_init_3 
<stdin>:15: PGRES_FATAL_ERROR select
"_testcluster3".determineIdxnameUnique('public.history', NULL);  -
ERROR:  Slony-I: table "public"."history" has no primary key
[17:49] u0235:slony-I# 

Although I've this:

table add key (node id = 1, fully qualified name = 'public.history');

I'm using the pgbench example as found on slony.info/.../firstdb.html

This is the full slonik script I use:
--------------------------------------------------------------------------------
[17:50] u0235:slony-I# cat slonik_init_3     
cluster name = testcluster3;

node 1 admin conninfo = 'dbname=pgbench host=localhost user=pgbench';
node 2 admin conninfo = 'dbname=pgbenchslave host=localhost
user=pgbench';

init cluster ( id=1, comment = 'Master Node' );

table add key (node id = 1, fully qualified name = 'public.history');

create set (id=1, origin=1, comment='All pgbench tables');

set add table (set id=1, origin=1, id=1, fully qualified name =
'public.accounts', comment='accounts table');
set add table (set id=1, origin=1, id=2, fully qualified name =
'public.branches', comment='branches table');
set add table (set id=1, origin=1, id=3, fully qualified name =
'public.tellers', comment='tellers table');
set add table (set id=1, origin=1, id=4, fully qualified name =
'public.history', comment='history table');

store node (id=2, comment = 'Slave node');
store path (server = 1, client =2, conninfo='dbname=pgbench
host=localhost user=pgbench');
store path (server = 2, client =1, conninfo='dbname=pgbenchslave
host=localhost user=pgbench');
[17:50] u0235:slony-I# 

--------------------------------------------------------------------------------

Anyone a hint on what I am doing wrong?

Sincerly

Nico

-- 
Think about Free and Open Source Software (FOSS).
http://nico.schottelius.org/documentations/foss/the-term-foss/

PGP: BFE4 C736 ABE5 406F 8F42  F7CF B8BE F92A 9885 188C
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20071017/c27ca159/attachment.pgp