Re: BUG #15451: Error adding foriegn key constraint

From: Andres Freund <andres(at)anarazel(dot)de>
To: harry(at)harryclarke(dot)me(dot)uk, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15451: Error adding foriegn key constraint
Date: 2018-10-22 19:12:07
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 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(at)harryclarke(dot)me(dot)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?


Andres Freund

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2018-10-22 19:12:08 Re: BUG #15451: Error adding foriegn key constraint
Previous Message PG Bug reporting form 2018-10-22 19:05:51 BUG #15451: Error adding foriegn key constraint