Re: Bug in detaching a partition with a foreign key. - Mailing list pgsql-hackers

From Álvaro Herrera
Subject Re: Bug in detaching a partition with a foreign key.
Date
Msg-id 202501210944.xxwv26wzh74k@alvherre.pgsql
Whole thread Raw
In response to Re: Bug in detaching a partition with a foreign key.  (Sami Imseih <samimseih@gmail.com>)
List pgsql-hackers
On 2025-Jan-20, Sami Imseih wrote:

> Patch looks good to me, but I am not sure about this part of the comment:
> 
> "Only the topmost one is to be considered here; the child constraints
> must be left alone,"
> 
> In this case, none of the pg_constraint entries are actually considered. right?

Right.  The parent one because it has conparentid = 0, the others
because their parent constraint is in the list.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/



pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: Non-text mode for pg_dumpall
Next
From: Alexander Korotkov
Date:
Subject: Re: table_tuple_lock's snapshot argument