Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types
Дата
Msg-id CAM3SWZRWU9UETXOEP-AYTb=EkPhiqCrFx0eTbRQ8M0iSpeTzpg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Ответы Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Список pgsql-hackers
On Wed, Aug 5, 2015 at 12:58 AM, Amit Langote
<Langote_Amit_f8@lab.ntt.co.jp> wrote:
> I forgot mentioning one thing later yesterday. The way exclRelTlist is
> initialized, all the way in the beginning (transformOnConflictClause), is
> most probably to blame. It uses expandRelAttrs() for other valid reasons;
> but within it, expandRTE() is called with 'false' for include_dropped
> (columns). I applied the attached (perhaps ugly) fix, and it seemed to fix
> the issue. But, I guess you'll be able to come up with some better fix.

Thanks for working on this. I think you have this right, but I also
don't think we should discuss this fix outside of the context of a
wider discussion about the excluded targetlist.

What I'm going to do is roll this into my own pending patch to fix the
issue with wholerow vars, which is also down to a problem with the
excluded targetlist initially generated by calling expandRelAttrs().
Andres might want to take an alternative approach with that, so a
consolidation makes sense.

-- 
Peter Geoghegan



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: tap tests remove working directories
Следующее
От: David Fetter
Дата:
Сообщение: Re: [patch] A \pivot command for psql