Re: ERROR: MergeAppend child's targetlist doesn't match MergeAppend - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: ERROR: MergeAppend child's targetlist doesn't match MergeAppend
Date
Msg-id 4EBA2E0C.2090106@sigaev.ru
Whole thread Raw
In response to Re: ERROR: MergeAppend child's targetlist doesn't match MergeAppend  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: type privileges and default privileges
Next
From: Thom Brown
Date:
Subject: Re: pg_comments (was: Allow \dd to show constraint comments)