| From: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| 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 04:10:31 |
| Message-ID: | 50485ddf-2e20-f787-90a8-a3d8e161ac35@lab.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2017/09/13 12:05, Simon Riggs wrote:
> 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?
Yes. See the last sentence in the description of PARTITION OF clause in
CREATE TABLE:
https://www.postgresql.org/docs/devel/static/sql-createtable.html#sql-createtable-partition
And, the 4th point in the list of differences between declarative
partitioning and inheritance:
Thanks,
Amit
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bossart, Nathan | 2017-09-13 04:12:12 | Re: [Proposal] Allow users to specify multiple tables in VACUUM commands |
| Previous Message | Amit Kapila | 2017-09-13 04:09:41 | Re: why not parallel seq scan for slow functions |