Re: partitioned tables referenced by FKs

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: partitioned tables referenced by FKs
Дата
Msg-id CA+TgmoY_amZOueJeR3K9wsLvpSKSQvKwNcCMTsHeXuAuHXC06A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: partitioned tables referenced by FKs  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, Apr 2, 2019 at 11:07 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The problem this patch is running into is that we'd like to make the
> validity of dropping a table partition depend on whether there are
> individual rows in some other table that FK-reference rows in the target
> partition.  That's just completely outside the object-dependency model,
> and I'm not sure why Robert finds that surprising.

I think it's because I was misunderstanding the problem.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Refactoring the checkpointer's fsync request queue
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation