| From: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Race between SELECT and ALTER TABLE NO INHERIT |
| Date: | 2017-09-15 06:41:33 |
| Message-ID: | 2d59b858-7b23-51db-54f6-6d1279b98de0@lab.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2017/09/15 15:36, Amit Langote wrote:
> The fact that
> parent is locked after the child and with ShareUpdateExclusiveLock instead
> of AccessExclusiveLock, we observe this race condition when SELECTing from
> the parent.
Oops, I meant "parent table is locked with AccessShareLock instead of
AccessExclusiveLock..."
Thanks,
Amit
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2017-09-15 06:47:10 | Re: pgsql: Add support for coordinating record typmods among parallel worke |
| Previous Message | Amit Langote | 2017-09-15 06:36:26 | Re: Race between SELECT and ALTER TABLE NO INHERIT |