Thu Apr 14 08:55:12 PDT 2005
- Previous message: [Slony1-general] cleanup
- Next message: [Slony1-general] Table has no unique index - is this a bug?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi. I'm using: PostgreSQL 8.0.2 Slony 1.0.5 initialized with the following script: ######## #! /bin/bash . testenv.sh psql master <<_EOPSQL_ drop table test2; create table test2 (testid int unique not null); _EOPSQL_ ## slony init stuff goes here .... ## init stuff end set add table (set id=1, origin=1, id=2, fully qualified name = 'public.test2', key = 'testid' ); ######### 'set add table' fails with error: <stdin>:14: PGRES_FATAL_ERROR select "_test".determineIdxnameUnique('public.test2', 'testid'); - ERROR: Slony-I: table public.test2 has nounique index testid I can add a table _only_ if I create primary key, but sometimes I cannot do this (because of existing multi-column PKEYs). Is this a bug, or I'm missing something? -- "First they ignore you. Then they laugh at you. Then they fight you. Then you win." - Mohandas Gandhi.
- Previous message: [Slony1-general] cleanup
- Next message: [Slony1-general] Table has no unique index - is this a bug?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list