On Thu, 2023-10-12 at 17:56 +0300, Олег Самойлов wrote: > 11.10.2023, 14:20, "Laurenz Albe" <laurenz.a...@cybertec.at>: > > On Wed, 2023-10-11 at 14:08 +0300, Олег Самойлов wrote: > > > 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. > > > > That is working as designed. You cannot detach a partition of a table if a > > foreign key points to it. > > Nope, of cause any can detach a partition of a empty table even if a foreign > key points to it.
You are right, and I was wrong. You can detach partitions from tables with a foreign key pointing to them. Yours, Laurenz Albe