BUG #16730: Create table like with inheritance and self referencing index

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: sofoklis24(at)gmail(dot)com
Subject: BUG #16730: Create table like with inheritance and self referencing index
Date: 2020-11-19 15:41:24
Message-ID: 16730-b902f7e6e0276b30@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16730
Logged by: Sofoklis Papasofokli
Email address: sofoklis24(at)gmail(dot)com
PostgreSQL version: 10.15
Operating system: PostgreSQL 10.15 (Ubuntu 10.15-1.pgdg20.04+1) on
Description:

The following simplified example used to work on previous versions, but not
on 10.15, we tested it again on version 10.11 and it works.

We read in the release notes of 10.15 that there is a change when using like
with inheritance, maybe it is related.

CREATE TABLE id_base
(
id SERIAL PRIMARY KEY

);

CREATE TABLE inherited_table
(
LIKE id_base INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING
INDEXES,

"self_ref_if" INT,

CONSTRAINT self_ref_id_fk FOREIGN KEY ("self_ref_if")
REFERENCES inherited_table (id) MATCH SIMPLE
ON UPDATE RESTRICT ON DELETE RESTRICT
)
INHERITS (id_base);

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Borisov 2020-11-19 15:54:54 Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted
Previous Message Alvaro Herrera 2020-11-19 13:31:35 Re: BUG #16726: Invalid input syntax is not a useful error message