没有唯一约束匹配给定键的引用表 [英] No unique constraint matching given keys for referenced table

问题描述

我有一个 date_dimension 表定义：

CREATE TABLE date_dimension
(
  id integer primary key,
  date text,
  year double precision,
  year_for_week double precision,
  quarter double precision
);

我正在尝试创建事实表失败

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 

我不确定如何解决此问题。

I am not sure how to fix this.

推荐答案

我认为您正在寻找两个单独的外键：

I think you are looking for two separate foreign keys:

foreign key (evaluation_date) references date_dimension(id),
foreign key (effective_date) references date_dimension(id)

这篇关于没有唯一约束匹配给定键的引用表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！