Wed Jan 30 09:10:10 PST 2008
- Previous message: [Slony1-general] table_id error??
- Next message: [Slony1-general] Notice message, should I be concerned?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
RTFM, I figured it out. The table id must be unique across sets, my
bad. The table id listed in the configuration file is the starting
table id.
Geoffrey wrote:
> I posted about this once before, but didn't get any bites. I'm hoping
> someone can enlighten me as to my error here. I have the following
> configuration:
>
> $SLONY_SETS = {
>
> "avldsSet" => {
> "set_id" => 1,
> "table_id" => 1,
> "sequence_id" => 1,
> "pkeyedtables" => [....],
> "keyedtables" => {},
> "serialtables" => [],
> "sequences" => [....],
> }
>
> "nonavldsSet" => {
> "set_id" => 2,
> "table_id" => 2,
> "sequence_id" => 2,
> "pkeyedtables" => [....],
> "keyedtables" => {},
> "serialtables" => [],
> "sequences" => [....],
> }
> };
>
> When I attempt to create the second set, I get an error as follows:
>
> 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
>
> Clearly, 'table id 2' has not been already defined. What is it that I'm
> missing here? 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
- Previous message: [Slony1-general] table_id error??
- Next message: [Slony1-general] Notice message, should I be concerned?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list