我在PostgreSql中收到错误:外键的引用和被引用列数不同意 [英] I get an error in PostgreSql: number of referencing and referenced columns for foreign key disagree

问题描述

我正在创建表，但出现此错误:

I'm creating a table, but I get this error:

• 不同意外键引用和被引用的列数.

我不知道该怎么解决.我认为声明3个外键可能是一个问题，但是我不确定.

I don't know how to solve it. I think that it may be a problem with declaring 3 foreign keys, but, I'm not sure about it.

出什么问题了?

Create table Trasllat
(
Data Date,
Codi_Empleat Integer,
Nom_agencia Varchar(30),
Data_fi Date,
Primary key (Data, Codi_Empleat),
Foreign key (Data) references Data on delete cascade,
Foreign key (Codi_empleat) references Empleat on delete cascade
Foreign key (Nom_agencia) references Agencia on delete cascade
);

推荐答案

这是因为您没有指定应引用的表的特定列名.您的外键声明应如下所示.请注意references Empleat(column_name)部分，它说Codi_empleat列引用了Empleat表column_name列.

That's because you are not specifying the specific column name of the table to which it should reference to. Your Foreign key declaration should look like below. Notice the part, references Empleat(column_name) it says that column Codi_empleat references to Empleat tables column_name column.

Foreign key (Data) references Trasllat(Data) on delete cascade,
Foreign key (Codi_empleat) references Empleat(column_name) on delete cascade
Foreign key (Nom_agencia) references Agencia(column_name) on delete cascade

检查 Postgres文档以获取有关同一内容的更多信息

Check Postgres Documentation to get more information on the same.

这篇关于我在PostgreSql中收到错误:外键的引用和被引用列数不同意的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！