primary key of partitioned table referenced by foreign table, v11,v12 clarification - Mailing list pgsql-admin

From Raj kumar
Subject primary key of partitioned table referenced by foreign table, v11,v12 clarification
Date
Msg-id CACxU--Xwzp=_7r0tuwe49jphAe07+7nEY130OuHcevX8fE1DPg@mail.gmail.com
Whole thread Raw
Responses Re: primary key of partitioned table referenced by foreign table,v11, v12 clarification
List pgsql-admin
Hi Team,

I am getting the below error when I am referencing Primary Key of parents table from checking table in Postgres version 11. I went through documentation of Postgres 12, where is mentioned that, "Primary key of the partitioned table can be referenced by other foreign tables."

I would like to know if the below error is something that is fixed or something else.

test=# insert into checking values(1,'tom',1);
ERROR:  insert or update on table "checking" violates foreign key constraint "checking_artist_fkey"
DETAIL:  Key (artist)=(1) is not present in table "parent".
test=#

pgsql-admin by date:

Previous
From: sandman42@libero.it
Date:
Subject: Tablespace size management questions
Next
From: Jeff Janes
Date:
Subject: Re: primary key of partitioned table referenced by foreign table,v11, v12 clarification