Re: BUG #16249: Partition pruning blocks on exclusively locked table partition - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16249: Partition pruning blocks on exclusively locked table partition
Date
Msg-id 29415.1581103064@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16249: Partition pruning blocks on exclusively locked table partition  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #16249: Partition pruning blocks on exclusively locked table partition  (0010203112132233 <boekewurm@gmail.com>)
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> In my humble opinion, this query should not be blocked during planning, as
> the partition can be pruned directly from the plan with the partition
> information that is available from the parent table: Partition information
> can be updated  when the partition is locked, but through the parent
> partitioned table. 

This case has been improved in PG v12.  It is operating as designed in
v11, however.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #16248: ALTER SYSTEM quoting of values does not work as expected
Next
From: Alvaro Herrera
Date:
Subject: Re: FK violation in partitioned table after truncating a referencedpartition