David Rowley <dgrowleyml(at)gmail(dot)com> writes:
> I've recently been thinking it would be good if you were unable to
> access partitions directly by name at all.
I strongly disagree. That's essentially betting the whole farm on
our always being able to optimize parent-level operations fully,
which I do not think we are anywhere close to.
> That would also get around
> the problem of having to lock all non-pruned partitions during queries
> to the partitioned table. Maybe it's too late for that though.
Yeah, I think we are locked into the current design now, for better
or worse.
regards, tom lane