Re: INSERT ... ON CONFLICT doesn't work

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jenda Krynicky <Jenda(at)krynicky(dot)cz>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: INSERT ... ON CONFLICT doesn't work
Date: 2021-12-01 19:59:17
Message-ID: CAKFQuwbW1GuTFzagq2ayuKs8rUOpdKLwzfuBWdBsp7AVcMpSCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 1, 2021 at 12:52 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> It's also possible to qualify the name in the ON CONFLICT clause,
> although I think you have to parenthesize it to do so:
>
> ... ON CONFLICT (("Lockers"."Uuid"))
>
>
This really needs to be confirmed and, if so, better documented on the
INSERT page, since adding a schema to the index_column_name does not
intuitively turn it into an index_expression which is what the syntax
diagram says requires an extra pair of parentheses.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2021-12-01 20:04:07 Re: INSERT ... ON CONFLICT doesn't work
Previous Message David G. Johnston 2021-12-01 19:54:44 Re: INSERT ... ON CONFLICT doesn't work