From: Tom Lane <tgl@sss.pgh.pa.us>
To: sofoklis24@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16730: Create table like with inheritance and self referencing index
Date: Thu, 19 Nov 2020 15:10:36 -0500
Message-ID: <1214697.1605816636@sss.pgh.pa.us> (raw)
In-Reply-To: <16730-b902f7e6e0276b30@postgresql.org>
References: <16730-b902f7e6e0276b30@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> 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.
Hmph. Apparently I was too careless about the order of execution of
the sub-commands created by a LIKE clause.
I pushed this patch:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=513db7b7004c8d1fa15dea4747a32cbc8f9621...
which takes care of the particular case you show, but now I wonder
if there are other issues lurking nearby. If you're in a position
to test this and see if it fixes your real application, please do.
Thanks for the report!
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, sofoklis24@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16730: Create table like with inheritance and self referencing index
In-Reply-To: <1214697.1605816636@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox