On Thu, Mar 22, 2001 at 06:33:16PM -0500, Jan Wieck wrote:
> Einar Karttunen wrote:
> How do you put a UNIQUE constraint on the entire inheritance
> hierarchie?
Easy. You make a unique index that covers an entire inheritance hierarchy.
If lots of table inherit a field "id" from a single table the you can put a
unique index on that field. All you need then is an index whose keys
reference not tuple IDs but (table ID, tuple ID) pairs.
Wow. I'm just thinking of how vacuum would deal with this. Probably not very
well. But it would give inheritance hierarchies very efficient lookups
rather than the implicit unioning done currently.
Martijn
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
