handling multiple matching constraints in DetachPartitionFinalize()

Поиск
Список
Период
Сортировка
От Zhihong Yu
Тема handling multiple matching constraints in DetachPartitionFinalize()
Дата
Msg-id CALNJ-vT-RfQeScWi3iQWPzwHgGnH=9X9kADPK5yQEFfeGn+AKw@mail.gmail.com
обсуждение исходный текст
Ответы Re: handling multiple matching constraints in DetachPartitionFinalize()  (Zhihong Yu <zyu@yugabyte.com>)
Список pgsql-hackers
Hi,
I was looking at the following code in DetachPartitionFinalize():

        /* If there's a constraint associated with the index, detach it too */
        constrOid = get_relation_idx_constraint_oid(RelationGetRelid(partRel),
                                                    idxid);

As mentioned in email thread `parenting a PK constraint to a self-FK one`, there may be multiple matching constraints, I think we should call ConstraintSetParentConstraint() for each of them.

This means adding a helper method similar to get_relation_idx_constraint_oid() which finds constraint and calls ConstraintSetParentConstraint().

I am preparing a patch.
Please let me know if my proposal makes sense.

Thanks

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

Предыдущее
От: Jacob Champion
Дата:
Сообщение: Re: [PATCH] Expose port->authn_id to extensions and triggers
Следующее
От: Nathan Bossart
Дата:
Сообщение: Re: [PATCH] Optimize json_lex_string by batching character copying