Wed Oct 17 09:24:52 PDT 2007
- Previous message: [Slony1-general] Problem initialising the cluster
- Next message: [Slony1-general] Re-enabling replication for dropped table.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Wednesday 17 October 2007 09:08:53 Brad Nicholson wrote:
> 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).
Yes in -HEAD it has been removed, do not expect this misfeature to be there in
1.3 once released.
> Add your own key to the table and use that.
--
Darcy Buskermolen
The PostgreSQL company, Command Prompt Inc.
http://www.commandprompt.com/
- Previous message: [Slony1-general] Problem initialising the cluster
- Next message: [Slony1-general] Re-enabling replication for dropped table.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list