Alexander Farber <alexander(dot)farber(at)gmail(dot)com> writes:
> Unfortunately, I get the error:
> ERROR: 42830: number of referencing and referenced columns for foreign key
> disagree
> How to refer to the (sid, social) FKs properly please?
You have to use the separate-constraint FK syntax:
CREATE TABLE words_payments (
sid text NOT NULL,
social integer NOT NULL ... ,
foreign key (sid, social) references words_social
);
Or in even more pedantic detail:
foreign key (sid, social) references words_social (sid, social)
You'd have to use that if (sid, social) were not the PK of words_social
but just some random unique key.
regards, tom lane