| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Race between SELECT and ALTER TABLE NO INHERIT |
| Date: | 2017-09-13 03:05:05 |
| Message-ID: | CANP8+jKYX8ZXihHNO+G=eLtyEsvTCEJFnz6Y_p8aHgfH7Sps0g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 26 June 2017 at 10:16, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> wrote:
> BTW, in the partitioned table case, the parent is always locked first
> using an AccessExclusiveLock. There are other considerations in that case
> such as needing to recreate the partition descriptor upon termination of
> inheritance (both the DETACH PARTITION and also DROP TABLE child cases).
Is this requirement documented or in comments anywhere?
I can't see anything about that, which is a fairly major usage point.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2017-09-13 03:05:31 | Re: WAL logging problem in 9.4.3? |
| Previous Message | Amit Langote | 2017-09-13 02:54:41 | Re: Setting pd_lower in GIN metapage |