MIME-Version: 1.0
References: <CAEzWdqfUnGNn1jpgVFr9+xCr5A-Pp9KjdxY=vv8E8iqqQ9OuFw@mail.gmail.com>
 <CAGeimVrmuHGCpg85oZuF0Y0DFDngEeYuceH8d3+Oe=Bu9-TrKA@mail.gmail.com> <CAEzWdqdGyJKuKJYmvi8Xm0M9xKvffcHS9wO4kQyFCnwTZLyd1w@mail.gmail.com>
In-Reply-To: <CAEzWdqdGyJKuKJYmvi8Xm0M9xKvffcHS9wO4kQyFCnwTZLyd1w@mail.gmail.com>
From: Muhammad Ikram <mmikram@gmail.com>
Date: Wed, 3 Jul 2024 08:18:27 +0500
Message-ID: <CAGeimVqaCqDmDWZf3hkTZk_8uXg4=4FU2MAcSRdrMqHriJyrwg@mail.gmail.com>
Subject: Re: Question on partman extension while relation exist
To: yudhi s <learnerdatabase99@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000df52ff061c4f49b3"
Archived-At: <https://www.postgresql.org/message-id/CAGeimVqaCqDmDWZf3hkTZk_8uXg4%3D4FU2MAcSRdrMqHriJyrwg%40mail.gmail.com>
Precedence: bulk

--000000000000df52ff061c4f49b3
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

 Sorry for late reply, I think you will having some script that drops and
creates daily partitions etc, command for disabling/removing any constraint
can be placed before these statements so that when the script runs it does
the needful.

Regards,
Muhammad Ikram
Bitnine global


On Tue, Jul 2, 2024 at 12:54=E2=80=AFPM yudhi s <learnerdatabase99@gmail.co=
m> wrote:

>
>
> 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 b=
y
> 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 y=
ou
> mean having that with another event trigger which will fire before drop?
>


--=20
Muhammad Ikram

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

<div dir=3D"ltr">Hi,<div><br><div>=C2=A0Sorry for late reply, I think you w=
ill having some script that drops and creates daily partitions etc, command=
 for disabling/removing any constraint can be placed before these statement=
s so that when the script runs it does the needful.</div><div><br></div><di=
v>Regards,</div><div>Muhammad Ikram</div><div>Bitnine global</div><div><br>=
</div></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"=
gmail_attr">On Tue, Jul 2, 2024 at 12:54=E2=80=AFPM yudhi s &lt;<a href=3D"=
mailto:learnerdatabase99@gmail.com">learnerdatabase99@gmail.com</a>&gt; wro=
te:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px =
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"=
auto"><br><br><div class=3D"gmail_quote" dir=3D"auto"><div dir=3D"ltr" clas=
s=3D"gmail_attr">On Tue, 2 Jul, 2024, 12:43 pm Muhammad Ikram, &lt;<a href=
=3D"mailto:mmikram@gmail.com" target=3D"_blank">mmikram@gmail.com</a>&gt; w=
rote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0p=
x 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div =
dir=3D"ltr">Hi Yudhi,<div><br></div><div dir=3D"auto">I think disabling for=
eign keys before maintenance will help.</div><div dir=3D"auto"><br></div></=
div></div><div><span class=3D"gmail_signature_prefix">-- </span><br><div di=
r=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><di=
v dir=3D"auto">Do you mean to say call the parent table first for maintenan=
ce followed by child, and remove all the foreign key first which are pointi=
ng to this parent table partition which is going to be dropped by the pg_pa=
rtman?=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">As drop/cre=
ate partition is being called from within pg_partman without our interventi=
on, so where should we put this drop foreign key code? Do you mean having t=
hat with another event trigger which will fire before drop?=C2=A0</div></di=
v>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><div>Muhammad Ikram<br><br></div></div></div>

--000000000000df52ff061c4f49b3--