Re: BUG #16730: Create table like with inheritance and self referencing index - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16730: Create table like with inheritance and self referencing index
Date
Msg-id 1214697.1605816636@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16730: Create table like with inheritance and self referencing index  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #16730: Create table like with inheritance and self referencing index
List pgsql-bugs
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=513db7b7004c8d1fa15dea4747a32cbc8f9621ef

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



pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: vacuumdb -Z can't find function declared on functional index with inline sql function
Next
From: Jaime Soler
Date:
Subject: Re: vacuumdb -Z can't find function declared on functional index with inline sql function