Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails
Дата
Msg-id 20230803090243.5ba3mapddthv6yhn@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails  (tender wang <tndrwang@gmail.com>)
Ответы Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails  (tender wang <tndrwang@gmail.com>)
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
Список pgsql-hackers
Дерево обсуждения 
On 2023-Aug-03, tender wang wrote:

> I think  old "sub-FK" should not be dropped, that will be violates foreign
> key constraint.

Yeah, I've been playing more with the patch and it is definitely not
doing the right things.  Just eyeballing the contents of pg_trigger and
pg_constraint for partitions added by ALTER...ATTACH shows that the
catalog contents are inconsistent with those added by CREATE TABLE
PARTITION OF.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Etsuro Fujita
Дата:
Сообщение: Re: Missing comments/docs about custom scan path
Следующее
От: Peter Smith
Дата:
Сообщение: Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication