Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with a "complex" upsert - Mailing list pgsql-admin

From Geoff Winkless
Subject Re: Problem with a "complex" upsert
Date
Msg-id CAEzk6ff6xJyujo88jUa4n2CtqYMJnKtJPXB9=9H2gSZxj+SdDA@mail.gmail.com
Whole thread Raw
In response to Problem with a "complex" upsert  (Mario De Frutos Dieguez <mariodefrutos@gmail.com>)
Responses Re: Problem with a "complex" upsert  (Mario de Frutos Dieguez <mariodefrutos@gmail.com>)
List pgsql-admin
Tree view
On Thu, 21 Jun 2018 at 15:07, Mario De Frutos Dieguez <mariodefrutos@gmail.com> 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

pgsql-admin by date:

Previous
From: Mario De Frutos Dieguez
Date:
Subject: Problem with a "complex" upsert
Next
From: Mario de Frutos Dieguez
Date:
Subject: Re: Problem with a "complex" upsert