我有一个date_dimension
表定义:
CREATE TABLE date_dimension
(
id integer primary key,
date text,
year double precision,
year_for_week double precision,
quarter double precision
);
我正在尝试创建一个失败的fact
表
create table fact (
id serial primary key,
contract integer,
component integer,
evaluation_date integer,
effective_date integer,
foreign key (evaluation_date, effective_date) references date_dimension(id, id)
);
错误是:
ERROR: there is no unique constraint matching given keys for referenced
table "date_dimension"
SQL state: 42830
我不确定如何解决这个问题。
发布于 2011-11-30 04:08:30
我认为您正在寻找两个独立的外键:
foreign key (evaluation_date) references date_dimension(id),
foreign key (effective_date) references date_dimension(id)
发布于 2011-11-30 04:15:13
您不是只想创建两个单独的外键引用date维度,如下所示:
create table fact (
id serial primary key,
contract integer,
component integer,
evaluation_date integer,
effective_date integer,
foreign key (evaluation_date) references date_dimension(id),
foreign key (effective_date) references date_dimension(id)
);
https://stackoverflow.com/questions/8317006
复制相似问题