Re: [GENERAL] Exclusively locking parent tables while disinheriting children.

2015-12-01 Thread Amit Langote
On Wed, Sep 16, 2015 at 12:10 AM, Thom Brown wrote: > On 7 August 2015 at 12:34, Thom Brown wrote: >> On 30 July 2015 at 13:35, Rowan Collins wrote: >>> So what I want to understand is what the risk of adding this lock are - >>> under what circumstances would I expect to see dead locks if I manu

Re: [GENERAL] Exclusively locking parent tables while disinheriting children.

2015-09-15 Thread Thom Brown
On 7 August 2015 at 12:34, Thom Brown wrote: > > On 30 July 2015 at 13:35, Rowan Collins wrote: > >> Hi, >> >> When working with partition sets, we're seeing occasional errors of >> "could not find inherited attribute..." in Select queries. This is >> apparently caused when an "ALTER TABLE ... N

Re: [GENERAL] Exclusively locking parent tables while disinheriting children.

2015-08-07 Thread Thom Brown
On 30 July 2015 at 13:35, Rowan Collins wrote: > Hi, > > When working with partition sets, we're seeing occasional errors of "could > not find inherited attribute..." in Select queries. This is apparently > caused when an "ALTER TABLE ... NO INHERIT" runs concurrently with another > transaction s