Re: ERROR: MergeAppend child's targetlist doesn't match MergeAppend

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: ERROR: MergeAppend child's targetlist doesn't match MergeAppend
Дата
Msg-id 4EBA2E0C.2090106@sigaev.ru
обсуждение исходный текст
Ответ на Re: ERROR: MergeAppend child's targetlist doesn't match MergeAppend  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения 
> After some thought and experimentation, the best fix seems to be to
> eliminate the ambiguity by wrapping subquery outputs in PlaceHolderVars
> whenever there is a risk of confusion.  The attached crude patch fixes
> both test cases.  It needs work (more comments and a regression test
> case would be good), but barring objection I'll push forward with doing
> it this way.

Thank you, your patch fixes original query too.

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: type privileges and default privileges
Следующее
От: Thom Brown
Дата:
Сообщение: Re: pg_comments (was: Allow \dd to show constraint comments)