Lock level of create table partition of

Started by Sergei Kornilovabout 5 years ago1 messages

Sergei Kornilov

sk@zsrv.org

about 5 years ago

Hello

In commit 898e5e3290a72d288923260143930fb32036c00c [1]https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=898e5e3290a72d288923260143930fb32036c00c we lowered the lock level on the parent relation. I found in discussion [2]/messages/by-id/20181025202622.d3x4y4ch7m4pxwnn@alvherre.pgsql:

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]: /messages/by-id/20181025202622.d3x4y4ch7m4pxwnn@alvherre.pgsql