Re: Bug in query rewriter - hasModifyingCTE not getting set

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug in query rewriter - hasModifyingCTE not getting set
Дата
Msg-id 3271906.1631111333@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bug in query rewriter - hasModifyingCTE not getting set  (Greg Nancarrow <gregn4422@gmail.com>)
Список pgsql-hackers
Greg Nancarrow <gregn4422@gmail.com> writes:
> On Wed, Sep 8, 2021 at 8:00 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Now, we could potentially make this work if we wrote code to run
>> through the copied rtable entries (recursively) and increment the
>> appropriate ctelevelsup fields by one.  That would essentially
>> have to be a variant of IncrementVarSublevelsUp that *only* acts
>> on ctelevelsup and not other level-dependent fields.  That's
>> what I meant when I spoke of moving mountains: the amount of code
>> that would need to go into this seems out of all proportion to
>> the value.  I think we should just throw an error, instead.
>> At least till such time as we see actual field complaints.

> [I don't think Tsunakawa-san will be responding to this any time soon]

Oh!  I'd not realized that he'd dropped out of the community, but
checking my mail folder, I don't see any messages from him in months
... and his email address is bouncing, too.  Too bad.

> I proposed a patch for this issue in a separate thread:
> https://www.postgresql.org/message-id/CAJcOf-f68DT=26YAMz_i0+Au3TcLO5oiHY5=fL6Sfuits6r+_w@mail.gmail.com

Right, that one looks like an appropriate amount of effort
(at least till someone gets way more excited about the case
than I am).  I will mark this CF item Returned With Feedback
and go see about that one.

            regards, tom lane



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

Предыдущее
От: oswaldo.bregnoles@planin.com.br
Дата:
Сообщение: Migração Postgresql 8.3 para versão Postgresql 9.3
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Avoid stuck of pbgench due to skipped transactions