Re: ATTACH/DETACH partitions and locking

2020-05-20 Thread Alvaro Herrera
On 2019-Jun-14, Pavel Luzanov wrote: > Does it make sense to change this way? > "Some operations require a stronger lock when using declarative partitioning > than when using table inheritance. For example, removing a > partition from a partitioned table requires taking an ACCESS EXCLUSIVE > lock

Re: ATTACH/DETACH partitions and locking

2019-06-14 Thread Pavel Luzanov
On 13.06.2019 23:07, Alvaro Herrera wrote: On 2019-Jun-13, Pavel Luzanov wrote: Hello, According to patch[1] and after playing with v12 beta1 I think that this item can be dropped from "5.11.3. Implementation Using Inheritance" section of v12 docs: "Some operations require a stronger lock w

Re: ATTACH/DETACH partitions and locking

2019-06-13 Thread Alvaro Herrera
On 2019-Jun-13, Pavel Luzanov wrote: > Hello, > > According to patch[1] and after playing with v12 beta1 I think that this > item can be dropped from "5.11.3. Implementation Using Inheritance" section > of v12 docs: > > "Some operations require a stronger lock when using declarative partitioning