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

From Laurenz Albe
Subject Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert
Date
Msg-id 9999548d8eb7f229cd82037e84093d4e6a4ede17.camel@cybertec.at
Whole thread Raw
In response to BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert
List 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@gmail.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



pgsql-bugs by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: error cache lookup failed in plpgsql function
Next
From: "Daniel Westermann (DWE)"
Date:
Subject: Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert