Re: Deadlock risk while inserting directly into partition?

David Rowley <dgrowleyml@gmail.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