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

From: Tender Wang <tndrwang(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Alexander Lakhin <exclusion(at)gmail(dot)com>
Subject: Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails
Date: 2024-07-23 02:15:47
Message-ID: CAHewXN=iWMKdeFM5ohaF473_vOYT9krUXB7OtcU3Tut-d7gJ=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 于2024年7月19日周五 21:18写道：

>
> I find this pair of queries useful; they show which constraints exist
> and which triggers belong to each. We need to make the constraints and
> triggers match after a detach right as things would be if the
> just-detached partition were an individual table having the same foreign
> key.
>

I don't find the useful queries in your last email. Can you provide them.
Thanks.

--
Tender Wang

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2024-07-23 02:36:53 Re: Normalize queries starting with SET for pg_stat_statements
Previous Message Tom Lane 2024-07-23 02:11:59 Re: xid_wraparound tests intermittent failure.