Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: exclusion(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert
Date: 2024-06-27 13:54:17
Message-ID: 9999548d8eb7f229cd82037e84093d4e6a4ede17.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sun, 2024-06-09 at 06:00 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 18500
> Logged by: Alexander Lakhin
> Email address: exclusion(at)gmail(dot)com
> PostgreSQL version: 17beta1
> Operating system: Ubuntu 22.04
> Description:

FYI, I think that the same problem just happened to me with v17beta2:

test=> CREATE TABLE p (id integer) PARTITION BY RANGE (id);
CREATE TABLE
test=> CREATE TABLE p_1 PARTITION OF p FOR VALUES FROM (1) TO (2);
CREATE TABLE
test=> ALTER TABLE p_1 ADD PRIMARY KEY (id);
ALTER TABLE
test=> CREATE UNIQUE INDEX ON p (id);
CREATE INDEX
test=> ALTER TABLE p DETACH PARTITION p_1;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Westermann (DWE) 2024-06-27 14:01:22 Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert
Previous Message Bertrand Drouvot 2024-06-27 12:57:02 Re: error cache lookup failed in plpgsql function