Postgres Pro
Downloads
Home   >   mailing lists

ATTACH PARTITION locking documentation for DEFAULT partitions - Mailing list pgsql-hackers

From Matthias van de Meent
Subject ATTACH PARTITION locking documentation for DEFAULT partitions
Date
Msg-id CAEze2WiTB6iwrV8W_J=fnrnZ7fowW3qu-8iQ8zCHP3FiQ6+o-A@mail.gmail.com
Whole thread Raw
Responses Re: ATTACH PARTITION locking documentation for DEFAULT partitions
List pgsql-hackers
Tree view 
Hi,

I recently noticed that ATTACH PARTITION also recursively locks the
default partition with ACCESS EXCLUSIVE mode when its constraints do
not explicitly exclude the to-be-attached partition, which I couldn't
find documented (has been there since PG10 I believe).

PFA a patch that documents just that.

With regards,

Matthias van de Meent.
Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: psql - add SHOW_ALL_RESULTS option
Next
From: Justin Pryzby
Date:
Subject: Re: ATTACH PARTITION locking documentation for DEFAULT partitions