Re: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree
Дата
Msg-id CAFj8pRAbVu_bMRRz0fZwH7iznzTjD0jUYw1Dnmbns=kAWS2ocQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers


po 23. 1. 2023 v 17:31 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
Pavel Stehule <pavel.stehule@gmail.com> writes:
> After some investigation, I found a problem in the RangeVar node.

> The field "catalogname" is setted to NULL in _readRangeVar, but it is
> compared in _equalRangeVar function.

> I thought so it is problem in my patch, but it looks like generic issue:

> create table postgres.public.foo(a int);
> WARNING:  outfuncs/readfuncs failed to produce an equal rewritten parse tree
> CREATE TABLE

Heh.  Probably we should just drop that special treatment of the
catalogname field --- that was always premature optimization,
given that (I think) we don't ever store RangeVar in the catalogs.

+1

Regards

Pavel


The alternative would be to also lobotomize comparisons of RangeVars
by marking the field equal_ignore, but what's the point?

                        regards, tom lane

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Non-superuser subscription owners
Следующее
От: Dean Rasheed
Дата:
Сообщение: Re: MERGE ... RETURNING