public inbox for [email protected]
help / color / mirror / Atom feedFrom: Alvaro Herrera <[email protected]>
To: Philipp Faster <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: How to attach partition with primary key
Date: Tue, 18 Jun 2024 16:43:40 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CALCf7UctU2Kn026e3Qz8+i+0CgH_BGMsMjoOwW1QD5nXysBrTA@mail.gmail.com>
On 2024-Jun-18, Philipp Faster wrote:
> I've done a bad job describing my issue in the first place: I left out a
> key definition statement that I thought doesn't play any role in the issue:
> another unique index on the same columns as PK.
I see. That unique index seems quite useless. Why not just drop it?
That would also solve your problem.
> Interesting thing is that if I define PK before the unique index and then
> drop it and redefine after the unique index, then the code still doesn't
> work. This behaviour smells like a bug on the PostgreSQL side...
Yeah, it sounds like we have a bug in the index-matching code, though
it depends on having a useless, duplicative index.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"Selbst das größte Genie würde nicht weit kommen, wenn es
alles seinem eigenen Innern verdanken wollte." (Johann Wolfgang von Goethe)
Ni aún el genio más grande llegaría muy lejos si
quisiera sacarlo todo de su propio interior.
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: How to attach partition with primary key
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox