Brad Nicholson bnichols at ca.afilias.info
Wed Oct 17 09:08:53 PDT 2007
On Wed, 2007-10-17 at 17:51 +0200, Nico Schottelius wrote:
> 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');

Yikes!!  Don't use table add key.  The developement team have
acknowledged it as a mis-feature, and it will be removed (I beleive).
Add your own key to the table and use that.

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.




More information about the Slony1-general mailing list