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