MIME-Version: 1.0
References: <CAEzWdqfUnGNn1jpgVFr9+xCr5A-Pp9KjdxY=vv8E8iqqQ9OuFw@mail.gmail.com>
 <CAGeimVrmuHGCpg85oZuF0Y0DFDngEeYuceH8d3+Oe=Bu9-TrKA@mail.gmail.com>
In-Reply-To: <CAGeimVrmuHGCpg85oZuF0Y0DFDngEeYuceH8d3+Oe=Bu9-TrKA@mail.gmail.com>
From: yudhi s <learnerdatabase99@gmail.com>
Date: Tue, 2 Jul 2024 13:24:07 +0530
Message-ID: <CAEzWdqdGyJKuKJYmvi8Xm0M9xKvffcHS9wO4kQyFCnwTZLyd1w@mail.gmail.com>
Subject: Re: Question on partman extension while relation exist
To: Muhammad Ikram <mmikram@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000058d3f8061c3f05af"
Archived-At: <https://www.postgresql.org/message-id/CAEzWdqdGyJKuKJYmvi8Xm0M9xKvffcHS9wO4kQyFCnwTZLyd1w%40mail.gmail.com>
Precedence: bulk

--00000000000058d3f8061c3f05af
Content-Type: text/plain; charset="UTF-8"

On Tue, 2 Jul, 2024, 12:43 pm Muhammad Ikram, <mmikram@gmail.com> wrote:

> Hi Yudhi,
>
> I think disabling foreign keys before maintenance will help.
>
> --
> Muhammad Ikram
>

Do you mean to say call the parent table first for maintenance followed by
child, and remove all the foreign key first which are pointing to this
parent table partition which is going to be dropped by the pg_partman?

As drop/create partition is being called from within pg_partman without our
intervention, so where should we put this drop foreign key code? Do you
mean having that with another event trigger which will fire before drop?

--00000000000058d3f8061c3f05af
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><br><br><div class=3D"gmail_quote" dir=3D"auto"><div dir=
=3D"ltr" class=3D"gmail_attr">On Tue, 2 Jul, 2024, 12:43 pm Muhammad Ikram,=
 &lt;<a href=3D"mailto:mmikram@gmail.com">mmikram@gmail.com</a>&gt; wrote:<=
br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;borde=
r-left:1px #ccc solid;padding-left:1ex"><div><div dir=3D"ltr">Hi Yudhi,<div=
><br></div><div dir=3D"auto">I think disabling foreign keys before maintena=
nce will help.</div><div dir=3D"auto"><br></div></div></div><div><span clas=
s=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_=
signature"><div dir=3D"ltr"><div>Muhammad Ikram<br></div></div></div></div>=
</blockquote></div><div dir=3D"auto"><br></div><div dir=3D"auto">Do you mea=
n to say call the parent table first for maintenance followed by child, and=
 remove all the foreign key first which are pointing to this parent table p=
artition which is going to be dropped by the pg_partman?=C2=A0</div><div di=
r=3D"auto"><br></div><div dir=3D"auto">As drop/create partition is being ca=
lled from within pg_partman without our intervention, so where should we pu=
t this drop foreign key code? Do you mean having that with another event tr=
igger which will fire before drop?=C2=A0</div></div>

--00000000000058d3f8061c3f05af--