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
