From: Nagaraj Raj <nagaraj.sf@yahoo.com>
To: Mike Sofen <msofen@runbox.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Partition column should be part of PK
Date: Fri, 9 Jul 2021 03:32:46 +0000 (UTC)
Message-ID: <613808845.2913413.1625801566230@mail.yahoo.com> (raw)
In-Reply-To: <080901d7744e$ac0f3d70$042db850$@runbox.com>
References: <20210708221703.GA1301@telsasoft.com>
<202107082228.obnak7c7mx4n@alvherre.pgsql>
<080901d7744e$ac0f3d70$042db850$@runbox.com>
My apologies for making confusion with new thread. Yes its same issue related to earlier post.
I was trying to figure out how to ensure unique values for columns (billing_account_guid, ban). If i add partition key to constraint , it wont be possible what im looking for.
My use case as below
INSERT INTO t1 SELECT * from t2 ON CONFLICT (billing_account_guid,ban) DO UPDATE SET something…
Or
INSERT INTO t1 SELECT * from t2 ON CONFLICT constraint (pk or uk)(billing_account_guid,ban) DO UPDATE SET something…
Thanks
Sent from Yahoo Mail for iPhone
On Thursday, July 8, 2021, 7:12 PM, Mike Sofen <msofen@runbox.com> wrote:
I believe this thread qualifies for the funniest thread of 2021 (so far). And yes, this is a top post. :-)
Mike Sofen
-----Original Message-----
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
Sent: Thursday, July 08, 2021 3:29 PM
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Nagaraj Raj <nagaraj.sf@yahoo.com>; pgsql-performance@postgresql.org
Subject: Re: Partition column should be part of PK
On 2021-Jul-08, Justin Pryzby wrote:
> If I'm not wrong, this is the same thing you asked 2 week ago.
>
> If so, why not continue the conversation on the same thread, and why
> not reference the old thread ?
>
> I went to the effort to find the old conversation.
> https://www.postgresql.org/message-id/20210625042228.GJ29179@telsasoft
> .com
Actually, it looks like you're replying to the same email you replied to two weeks ago.
--
Álvaro Herrera Valdivia, Chile — https://www.EnterpriseDB.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: nagaraj.sf@yahoo.com, msofen@runbox.com, alvherre@alvh.no-ip.org, pryzby@telsasoft.com
Subject: Re: Partition column should be part of PK
In-Reply-To: <613808845.2913413.1625801566230@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox