Home > mailing lists

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

From	Geoff Winkless
Subject	Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types
Date	August 3, 2015 19:05:06
Msg-id	CAEzk6fd8_ByyTvz+vkFuhk5rBoHu2QRtCfPkNrO78ViLeVkAUA@mail.gmail.com Whole thread Raw
In response to	ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types (Geoff Winkless <pgsqladmin@geoff.dj>)
List	pgsql-hackers

On 3 August 2015 at 16:53, Geoff Winkless <pgsqladmin@geoff.dj> wrote:

If I create a copy of the table using

CREATE mytab (LIKE brokentab INCLUDING ALL);

Of course I meant CREATE TABLE here... finger slippage :)

From: Alvaro Herrera
Date: 03 August 2015, 19:00:56
Subject: Re: Planner debug views

From: Jeff Janes
Date: 03 August 2015, 19:18:31
Subject: Re: optimizing vacuum truncation scans