MIME-Version: 1.0
From: veem v <veema0000@gmail.com>
Date: Thu, 30 Apr 2026 08:07:21 +0530
Message-ID: <CAB+=1TVS7o=uBorTNjXHzhLO3pJQOwZOYDWoGMJFqLTc9S8ZRw@mail.gmail.com>
Subject: Issue during partition drop
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000af858d0650a458bf"
Archived-At: <https://www.postgresql.org/message-id/CAB%2B%3D1TVS7o%3DuBorTNjXHzhLO3pJQOwZOYDWoGMJFqLTc9S8ZRw%40mail.gmail.com>
Precedence: bulk

--000000000000af858d0650a458bf
Content-Type: text/plain; charset="UTF-8"

Hi,
We have the Aurora Postgres database. And for a table with PK-FK
relationships, we have been running into issues while dropping partitions
using partman. We have planned to detach and drop the partitions but end up
with the below error , so wanted to understand, if this is expected
behaviour and how to handle it?

ERROR:  cannot drop table <table_name>_p20250202 because other objects
depend on it
CONTEXT: SQL statement "DROP TABLE <table_name>_p20250202"
PL/pgSQL function
drop_partition_time(text,interval,boolean,boolean,text,timestamp with time
zone) line 250 at EXECUTE
PL/pgSQL function partman.run_maintenance(text,boolean,boolean) line 336 at
assignment
DETAIL: constraint <constraint_name>_fkey on table <table_name> depends on
table <table_name>_p20250202

Regards
Veem

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

<div dir=3D"ltr">Hi,<br>We have the Aurora Postgres database. And for a tab=
le with PK-FK relationships, we have been running into issues while droppin=
g partitions using partman.=C2=A0We have planned to detach and drop the par=
titions but end up with the below error , so wanted to understand, if this =
is expected behaviour and how to handle it?<br>=C2=A0<br>ERROR:=C2=A0 canno=
t drop table &lt;table_name&gt;_p20250202 because other objects depend on i=
t<br>CONTEXT: SQL statement &quot;DROP TABLE &lt;table_name&gt;_p20250202&q=
uot;<br>PL/pgSQL function drop_partition_time(text,interval,boolean,boolean=
,text,timestamp with time zone) line 250 at EXECUTE<br>PL/pgSQL function pa=
rtman.run_maintenance(text,boolean,boolean) line 336 at assignment<br>DETAI=
L: constraint &lt;constraint_name&gt;_fkey on table &lt;table_name&gt; depe=
nds on table &lt;table_name&gt;_p20250202<br><div><br></div><div>Regards</d=
iv><div>Veem</div></div>

--000000000000af858d0650a458bf--