Hello, I receive the following error when creating a foreign key between two partitioned tables. ERROR: there is no unique constraint matching given keys for referenced table "par_log_file"
Here is my setup: CREATE TABLE par_log_file ( par_file_id character varying(20) NOT NULL, par_id character varying(64) NOT NULL ) PARTITION BY RANGE (par_file_id) ; ALTER TABLE ONLY par_log_file ADD CONSTRAINT plf_pk PRIMARY KEY (par_file_id); -- CREATE TABLE par_log_definition ( par_file_id character varying(20) NOT NULL, tif_seq_nmbr bigint NOT NULL, name_25 character varying(255) ) PARTITION BY RANGE (par_file_id) ; ALTER TABLE ONLY par_log_definition ADD CONSTRAINT pld_pk PRIMARY KEY (par_file_id, tif_seq_nmbr); CREATE INDEX pld_idx ON par_log_definition USING btree (par_file_id); ALTER TABLE par_log_definition ADD CONSTRAINT pld_fk FOREIGN KEY (par_file_id) REFERENCES par_log_file(par_file_id); Version Postgres 13.13 Any help would be appreciated/ -- Michael Corey