ERROR: UNIQUE constraint matching given keys for referenced table "rl_voltas" not found

Поиск

Список

Период

Сортировка

От	Rui Pires
Тема	ERROR: UNIQUE constraint matching given keys for referenced table "rl_voltas" not found
Дата	16 июля 2003 г. 19:54:48
Msg-id	004901c34bed$7c95f2c0$0301a8c0@rui обсуждение исходный текст
Ответы	Re: ERROR: UNIQUE constraint matching given keys for
Список	pgsql-general

Дерево обсуждения

Hi! I'm a beginer in PosrgreSQL, and I have a problem I can't resolve.

The script is the following :

CREATE TABLE RL_RefVoltas(
NVolta SERIAL NOT NULL PRIMARY KEY,
Designacao VARCHAR(15) NOT NULL,
Tipo INT NOT NULL
);

CREATE TABLE RL_Voltas(
NVolta INT NOT NULL,
Data DATE NOT NULL,
Hora TIME NOT NULL,
Matricula VARCHAR(9),
NLitros INT,
PRIMARY KEY (Data,Hora),
foreign key (NVolta)references RL_RefVoltas(NVolta)
);

CREATE TABLE RL_Cisterna(
NVolta INT NOT NULL,
Data DATE NOT NULL,
Hora TIME NOT NULL,
NCist INT NOT NULL PRIMARY KEY, /*1 a 4*/
Acidez INT,
ProvaAlcool BOOL,
TFermentacao TIME,
Fermentacao FLOAT,
foreign key (NVolta, Data, Hora) references RL_Voltas(NVolta, Data, Hora)
);

The result of executing this script is :

ERROR: UNIQUE constraint matching given keys for referenced table "rl_voltas" not found

Anybody can tell me why?

Thanks, and good work.

В списке pgsql-general по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

ERROR: UNIQUE constraint matching given keys for referenced table "rl_voltas" not found