Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT
Дата
Msg-id 201901181808.5srgir3zfzhc@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
On 2019-Jan-17, Alvaro Herrera wrote:

> Well, the whole point of my proposal is that the FK-creating code
> recurses to partitions by calling ATAddForeignKeyConstraint, and IMO
> that's the wrong level to recurse at; we should instead recurse by
> calling clone_fk_constraints() as a whole.  That's not readibly possible
> with the current code arrangement because of layering, but after
> backpatching (as attached) the two patches I mentioned, I end up with
> the following, which I think is much cleaner.  (Also, this code layout
> plays much better with my project to continue to extend FKs so that they
> are allowed to point to partitioned tables; see the other thread).
> 
> The attached patches are for pg11; they don't apply to master.  The
> changes are uninteresting.

Pushed this.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15598: PostgreSQL Error Code is not reported when connection terminated due to idle-in-transaction timeout
Следующее
От: "Nithyanantham Shanmugam (nithshan)"
Дата:
Сообщение: pg_upgrade issue in windows 7