Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15451: Error adding foriegn key constraint - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #15451: Error adding foriegn key constraint
Date
Msg-id 20181022191208.po23ymm4c45qziqk@alvherre.pgsql
Whole thread Raw
In response to BUG #15451: Error adding foriegn key constraint  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view 
On 2018-Oct-22, PG Bug reporting form wrote:

> ERROR: constraints on permanent tables may reference only permanent tables
> 
> ALTER TABLE bnm.table1
>     ADD CONSTRAINT id_fk FOREIGN KEY (bnm_id)
>     REFERENCES bnm.table2 (id) MATCH SIMPLE
>     ON UPDATE NO ACTION
>     ON DELETE NO ACTION;

Is table2 an unlogged table perchance?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #15451: Error adding foriegn key constraint
Next
From: PG Bug reporting form
Date:
Subject: BUG #15452: 10.5 and reproducible "ERROR: could not read block 0 infile..." when creating functional index