Re: Bug in detaching a partition with a foreign key.

From: Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Sami Imseih <samimseih(at)gmail(dot)com>
Cc: Amul Sul <sulamul(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in detaching a partition with a foreign key.
Date: 2025-01-20 15:26:35
Message-ID: 202501201526.qvxjk2ptyqop@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2025-Jan-20, Sami Imseih wrote:

> Below is the repro I used. Similar as you original repro,
> but without subpartition on foo_p0. This also results in the segfault
> with your attached patch.

I think the issue in Amul's patch is just that the list was not
initialized to NIL.

Other than the lack of comments, which I'm in the process of writing,
the initial patch Amul submitted seems largely correct to me, in my
understanding of the situation. I'll throw in a few tests, hoping that
it'll prove correct, and if so then I'll get it pushed soon.

--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"El hombre nunca sabe de lo que es capaz hasta que lo intenta" (C. Dickens)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sami Imseih 2025-01-20 15:35:22 Re: Bug in detaching a partition with a foreign key.
Previous Message Sami Imseih 2025-01-20 15:15:08 Re: Bug in detaching a partition with a foreign key.