On Wed, 14 Aug 2002, Tom Lane wrote: > It's nonlocal constraints that are the problem, and here foreign keys > and UNIQUE constraints are certainly the canonical examples. Both of > these would be largely solved with table-spanning indexes I think.
Note that the other obvious way to solve this would be to store all of the information inherited from the parent in the parent table, so that you don't have to do anything special to make all of the constraints and whatnot apply. cjs -- Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.netbsd.org Don't you know, in this new Dark Age, we're all light. --XTC ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
