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

From Andres Freund
Subject Re: BUG #15451: Error adding foriegn key constraint
Date
Msg-id 20181022191207.w7l5a3fuquswvbl7@alap3.anarazel.de
Whole thread Raw
In response to BUG #15451: Error adding foriegn key constraint  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On 2018-10-22 19:05:51 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      15451
> Logged by:          Harry Clarke
> Email address:      harry@harryclarke.me.uk
> PostgreSQL version: 10.5
> Operating system:   Windows Server 2008 R2 standard
> Description:        
> 
> When trying to create a table, or to add a foreign key constraint to a
> table, an error (see below) is produced. However, both tables are permanent
> tables, and there are no temporary tables that I am aware of.
> 
> ERROR: constraints on permanent tables may reference only permanent tables

Note that unlogged tables are also considered not permanent. Is that it?

Greetings,

Andres Freund


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15451: Error adding foriegn key constraint
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #15451: Error adding foriegn key constraint