Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
> Hmm. You are right, but without that we won't be able to enforce
> uniqueness on the partitioned table (we could only enforce it on each
> partition, which would mean we can't partition on anything else than
> primary keys if the tables have one). IMHO this is something to
> consider.
Well, partitioning on the primary key would be Good Enough for 95% or
99% of the real problems out there. I'm not excited about adding a
large chunk of complexity to cover another few percent.
regards, tom lane