Tue Dec 18 16:48:23 PST 2007
- Previous message: [Slony1-general] error when running slonik_create_set
- Next message: [Slony1-general] Bad failure mode encountered during EXECUTE SCRIPT (maybe fixed in 1.2.12?)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Geoffrey wrote:
> The first time I attempted to run slonik_create_set, I discovered I had
> a table that did not have a primary key. I don't need to replicate this
> table so I removed it from my configuration file. I received the
> following error which was quite clear to me:
>
> <stdin>:162: PGRES_FATAL_ERROR select
> "_esc_cluster".determineIdxnameUnique('public.esc_class', NULL); - ERROR:
> Slony-I: table "public"."esc_class" has no primary key
>
>
> So I ran slonik_drop_set and then re-ran slonik_create_set. I then
> received a similar error:
>
> <stdin>:374: PGRES_FATAL_ERROR select
> "_esc_cluster".determineIdxnameUnique('public.65280', NULL); - ERROR:
> Slony-I: determineIdxnameUnique(): table "public"."65280" not found
>
>
> It appears to me that it's looking for a table named 65280, but I do not
> have any such table in my slon_tools.conf file.
>
> Any clues as to what is going on here would be appreciated.
A little more info. When looking at the output of slonik_create_set,
the error comes just after adding a table named 'settle.' The weird
thing is that the next few tables in the slon_tools.conf file are:
stat, system, trac
But the output attempts to add a table named 65280, then the 'trac'
table, so I don't see it trying to add the 'stat' or 'system' tables.
After this one anomaly, the rest of the output is correct.
--
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] error when running slonik_create_set
- Next message: [Slony1-general] Bad failure mode encountered during EXECUTE SCRIPT (maybe fixed in 1.2.12?)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list