Search Postgresql Archives

Foreign Key error between two partitioned tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux