Markus Schiltknecht <markus@bluegap.ch> writes:
> Uh.. can you elaborate on that? AFAICS, you would simply have to query
> multiple btree indexes and make sure non of them is violated.
That only works for the partition-key indexes, ie, ones where you can be
sure a-priori that there cannot be duplicate keys in two different indexes.
I believe the complaint here is that people would like to be able to
enforce uniqueness across the whole partitioned table on columns that
are not part of the partition key.
(But that sounds rather like pie in the sky, actually. Which other
databases can do that, and how do they do it?)
regards, tom lane