Re: Problem with a "complex" upsert

[Geoff Winkless <pgsqladmin@xxxxxxxx>]

On Thu, 21 Jun 2018 at 15:07, Mario De Frutos Dieguez <mariodefrutos@xxxxxxxxx> wrote:

ON CONFLICT (geoid) DO UPDATE SET (b01003001) = ROW(EXCLUDED.b01003001);

​

At first glance, shouldn't the query simply be

 SET b01003001 = EXCLUDED.b01003001;

?

The second part of your email does suggest a bug though, syntax shouldn't cause a crash.

Geoff