Hi,
 =

I ran into the same "problem". Its not possible to have the same table in m=
ore then one set due to a unique constraint.
 =

Jaco

________________________________

Van: slony1-general-bounces at lists.slony.info namens slony1-general-request@=
lists.slony.info
Verzonden: vr 25-1-2008 21:00
Aan: slony1-general at lists.slony.info
Onderwerp: Slony1-general Digest, Vol 11, Issue 27



Send Slony1-general mailing list submissions to
        slony1-general at lists.slony.info

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.slony.info/mailman/listinfo/slony1-general
or, via email, send a message with subject or body 'help' to
        slony1-general-request at lists.slony.info

You can reach the person managing the list at
        slony1-general-owner at lists.slony.info

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Slony1-general digest..."


Today's Topics:

   1. problem creating a 2nd set (Geoffrey)
   2. how does one 'un-init' a cluster? (Geoffrey)


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

Message: 1
Date: Fri, 25 Jan 2008 10:13:52 -0500
From: Geoffrey <lists at serioustechnology.com>
Subject: [Slony1-general] problem creating a 2nd set
To: Slony List <slony1-general at lists.slony.info>
Message-ID: <4799FCB0.2070706 at serioustechnology.com>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

I must be missing something here.  I'll summarize so as to reduce the
size of the example.  I have two sets defined in a config file as follows:

$SLONY_SETS =3D {

        "avldsSet" =3D> {
                "set_id"       =3D> 1,
                "table_id"     =3D> 1,
                "sequence_id"  =3D> 1,
                "pkeyedtables" =3D> [....],
                "keyedtables"  =3D> {},
                "serialtables" =3D> [],
                "sequences"    =3D> [....],
        }

        "nonavldsSet" =3D> {
                "set_id"       =3D> 2,
                "table_id"     =3D> 2,
                "sequence_id"  =3D> 2,
                "pkeyedtables" =3D> [....],
                "keyedtables"  =3D> {},
                "serialtables" =3D> [],
                "sequences"    =3D> [....],
        }
};

So then my expectation is that I will need to run the following:

slonik_create_set --config $CONFIG 1 |slonik
slonik_create_set --config $CONFIG 2 |slonik

Because I've defined two sets.  Problem is, I received the following
error when I run the second slonik_create_set:

slonik_create_set --config $CONFIG 2|slonik
<stdin>:16: Subscription set 2 created
<stdin>:17: Adding tables to the subscription set
<stdin>:18: PGRES_FATAL_ERROR select "_mwv_cluster".setAddTable(2, 2,
'public.aaccess', 'aaccess_pkey', 'Table public.aaccess with primary
key');  - ERROR:  Slony-I: setAddTable_int: table id 2 has already been
assigned!
CONTEXT:  PL/pgSQL function "setaddtable" line 37 at perform

The table mentioned 'aaccess' only exists in the first set.  Do I
misunderstand the concept of sets or the functionality of the
slonik_create_set script?

Thanks for any assistance.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin


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

Message: 2
Date: Fri, 25 Jan 2008 10:20:23 -0500
From: Geoffrey <lists at serioustechnology.com>
Subject: [Slony1-general] how does one 'un-init' a cluster?
To: slony <slony1-general at lists.slony.info>
Message-ID: <4799FE37.8060206 at serioustechnology.com>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

I don't know if that makes sense, but how do you undo what
slonik_init_cluster does?

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin


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

_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general


End of Slony1-general Digest, Vol 11, Issue 27
**********************************************




This e-mail and any attachment is for authorised use by the intended recipi=
ent(s) only. It may contain proprietary material, confidential information =
and/or be subject to legal privilege. It should not be copied, disclosed to=
, retained or used by, any other party. If you are not an intended recipien=
t then please promptly delete this e-mail and any attachment and all copies=
 and inform the sender. Thank you.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 8316 bytes
Desc: not available
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20080128=
/e4bacf53/attachment-0001.bin