On Wed, Apr 04, 2007 at 10:07:39AM -0400, Andrew Dunstan wrote: > Simon Riggs wrote: > >My hope is to have a mechanism to partition indexes or recognise > >that they are partitioned, so that a set of provably-distinct > >unique indexes can provide the exact same functionlity as a single > >large unique index, just without the management nightmare. > > Will this address the fairly common data design problem where we > need to ensure that a given value is unique across several tables > (possibly siblings, possibly not)?
That would be where the provably-distinct part comes in, so yes. > If so, then full steam ahead. Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http://www.postgresql.org/about/donate ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
