Thu Nov 23 20:46:03 PST 2006
- Previous message: [Slony1-general] Error in setting up slony
- Next message: [Slony1-general] Error in setting up slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
"Pradeep Parmar" <parmarpradeep at gmail.com> writes:
>> You will need to have primary keys on the tables for which you want to replicate data...
> But slonik comand "TABLE ADD KEY" allows to create a key for the tables which don't have a primary key.
> I'm using the same command for such tables in my database still encountering the error
> <stdin>:7: PGRES_FATAL_ERROR select "_slash".determineIdxnameUnique(' public.staff', NULL);? - ERROR:? Slony-I: table "public"."staff" has no primary key
Yes, there is a command to support this; it is considered by various
of the developers to be a misfeature.
If you add a proper primary key to table "public"."staff", then that
will resolve the issue.
I decline to help figure out how to use a deprecatable feature.
--
(format nil "~S@~S" "cbbrowne" "ca.afilias.info")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
- Previous message: [Slony1-general] Error in setting up slony
- Next message: [Slony1-general] Error in setting up slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list