Thread: Lock level of create table partition of

Lock level of create table partition of

From

Sergei Kornilov

Date:

17 December 2020, 15:41:48

Hello

In commit 898e5e3290a72d288923260143930fb32036c00c [1] we lowered the lock level on the parent relation. I found in
discussion[2]:
 

> David Rowley recently pointed out that we can modify
> CREATE TABLE ..  PARTITION OF to likewise not obtain AEL anymore.
> Apparently it just requires removal of three lines in MergeAttributes.

But on current HEAD "create table ... partition of" still require AccessExclusiveLock on the parent relation. It's
neccessary?

regards, Sergei

[1]: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=898e5e3290a72d288923260143930fb32036c00c
[2]: https://www.postgresql.org/message-id/20181025202622.d3x4y4ch7m4pxwnn%40alvherre.pgsql