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

Поиск
Список
Период
Сортировка
От Sofoklis Papasofokli
Тема Re: BUG #16730: Create table like with inheritance and self referencing index
Дата
Msg-id CANNe48dv3KzRR+VWQm7vYYm3zLcBS1_WP+zBBDm1bu3o40=fjA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #16730: Create table like with inheritance and self referencing index  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #16730: Create table like with inheritance and self referencing index  (Sofoklis Papasofokli <sofoklis24@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
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@sss.pgh.pa.us> wrote:
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


--
Sofoklis

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jaime Soler
Дата:
Сообщение: Re: vacuumdb -Z can't find function declared on functional index with inline sql function
Следующее
От: Mihir Pandya
Дата:
Сообщение: Re: BUG #16725: PG Admin 4 not loading due to Mime mistmatch