| 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 |
| Message-ID: | 20181022191207.w7l5a3fuquswvbl7@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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?
Greetings,
Andres Freund
| 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 |