On Tue, 2008-06-03 at 13:06 -0500, Mason Hale wrote: > On Tue, Jun 3, 2008 at 12:04 PM, Jeff Davis <pgsql@xxxxxxxxxxx> wrote: > > On Tue, 2008-06-03 at 09:43 -0500, Mason Hale wrote: > >> I've been working on partitioning a rather large dataset into multiple > >> tables. One limitation I've run into the lack of cross-partition-table > >> unique indexes. In my case I need to guarantee the uniqueness of a > >> two-column pair across all partitions -- and this value is not used to > >> partition the tables. The table is partitioned based on a insert date > >> timestamp. > > > > You're looking for a constraint across tables. > > > > Yes, for this particular case. But I'm also interested in speeding up > cross-partition queries whether it is for a uniqueness check or not. > This uniqueness check is just one (important) instance of a > cross-partition query. I simple way to do this (potentially) would be to push the trigger to C. Joshua D. Drake
