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

Hi Tom,

Just writing to confirm that i managed to patch the 10.15 version with your
fix and run all our scripts.
Everything runs normally.

Thanks for the great work!

On Fri, Nov 20, 2020 at 12:32 PM Sofoklis Papasofokli <sofoklis24(at)gmail(dot)com>
wrote:

> Hi Tom,
>
> Thanks for the quick response.
>
> I have not done a patch before, I will try to figure it out over the
> weekend and get back to you on how it works for our exact scenario.
>
> Thanks again!
>
> Best regards,
> Sofoklis
>
> On Thu, Nov 19, 2020 at 10:10 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> PG Bug reporting form <noreply(at)postgresql(dot)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
>>
>
>
> --
> Sofoklis
>

--
Sofoklis