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

Поиск
Список
Период
Сортировка
Искать
От
Jehan-Guillaume de Rorthais
Тема
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails
Дата
Msg-id
20241023100154.661231ca@karst
Ответ на
Список
Дерево обсуждения
[BUG] Fix DETACH with FK pointing to a partitioned table fails Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Alvaro Herrera <alvherre@alvh.no-ip.org>
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 Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Jehan-Guillaume de Rorthais <jgdr@dalibo.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 Alvaro Herrera <alvherre@alvh.no-ip.org>
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 Alvaro Herrera <alvherre@alvh.no-ip.org>
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 Junwang Zhao <zhjwpku@gmail.com>
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Junwang Zhao <zhjwpku@gmail.com>
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Alvaro Herrera <alvherre@alvh.no-ip.org>
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 Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Jehan-Guillaume de Rorthais <jgdr@dalibo.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>
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 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 Tender Wang <tndrwang@gmail.com>
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Alvaro Herrera <alvherre@alvh.no-ip.org>
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 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 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 Alvaro Herrera <alvherre@alvh.no-ip.org>
On Tue, 22 Oct 2024 16:32:33 +0200
Alvaro Herrera  wrote:

> On 2024-Oct-22, Jehan-Guillaume de Rorthais wrote:
> 
> > On Fri, 18 Oct 2024 16:50:59 +0200
> > Alvaro Herrera  wrote:  
> 
> > > For branch 14, I opted to make it delete the constraints on detach.
> > > This isn't ideal but unless somebody wants to spend a lot more time on
> > > this, it seems the best we can do.  Leaving broken constraints around
> > > seems worse.   
> > 
> > Keep that in mind, and move ahead to the next level: self-FK on partitioned
> > table! ;-)
> > 
> > https://www.postgresql.org/message-id/flat/20230707175859.17c91538%40karst#0dc7b8afd8b780899021bbb075598250  
> 
> Yeah.  I pushed these patches finally, thanks!

Great! Many thanks Alvaro and Tender for your work on this issue.


В списке pgsql-hackers по дате отправления
От: Peter Smith
Дата:
От: Robert Haas
Дата:
FAQ