Postgres Pro
Downloads
Home   >   mailing lists

Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types
Date
Msg-id CAM3SWZQAav_oYKwRcEtgAV6GghF1QC9Ry0qkdUgPxA=M_4J34A@mail.gmail.com
Whole thread Raw
In response to Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-hackers
Tree view 
On Tue, Aug 4, 2015 at 2:29 AM, Amit Langote
<Langote_Amit_f8@lab.ntt.co.jp> wrote:
> Perhaps, it may have to do with how EXCLUDED pseudo-rel's targetlist is
> manipulated through parse-plan stage?

I think so, yes.

I'll look into writing a fix for this later in the week.

Thanks for the report, Geoff, and thanks for the analysis Amit.

-- 
Peter Geoghegan

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Sharing aggregate states between different aggregate functions
Next
From: Ewan Higgs
Date:
Subject: Re: [sqlsmith] Failed assertion in joinrels.c