Can not drop partition if exist foreign keys

From: Олег Самойлов <splarv(at)ya(dot)ru>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Can not drop partition if exist foreign keys
Date: 2023-10-11 11:08:54
Message-ID: 5E197F1B-BDDF-40AF-9D87-D6792CE1A3B9@ya.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.
There are two common practice to drop partition from partitioned table: just drop or detach-drop. But simple drop don't work if exist foreign key. Example script attached.

Attachment Content-Type Size
test.sql application/octet-stream 374 bytes
unknown_filename text/plain 1021 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2023-10-11 11:17:57 Re: Can not drop partition if exist foreign keys
Previous Message Laurenz Albe 2023-10-11 07:45:51 Re: A question about possible recovery inconsistency