Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id EE5CBAD7E31 for ; Sun, 17 Jun 2012 14:32:08 -0300 (ADT) Received: from mail-pb0-f46.google.com ([209.85.160.46]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SgJKY-0008BG-Pg for pgsql-hackers@postgresql.org; Sun, 17 Jun 2012 17:32:07 +0000 Received: by pbbrp8 with SMTP id rp8so7307709pbb.19 for ; Sun, 17 Jun 2012 10:31:52 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:subject:from:to:cc:date:in-reply-to:references :content-type:x-mailer:content-transfer-encoding:mime-version :x-gm-message-state; bh=m919SpzSTtt1ep6yy83yNri/FpaOvAd3+qrT4hhQHW4=; b=mzJ1pzb4csqHBBBMoW47kMh4URmD24UXhSYOvYXid5lr/LPwGR7Rt9K1wrqmLu8GTc HDnsB3o9dsXjQrXTdGY3kUb9U+5vgVUdKDViotsNydlxhgLSgEdVIY2b3XJcHzKOq9nl TJl2BjN9/h6boQAj5PEbmdoT26nFeB0Vym2Pu+12pdS7UOMpwRTDKqwcVaJVu3TArT7p M+CyJf6PfJfpEfd8nTCIHHnLd0j9p3IhwV+avj+OmBqx2191+SNFo94hzwomE6lq0fng g4ZjCX8IJnP7tkJ2K3XA2//r7FXOlPoDQHHP3rqx4bNu8bBw6U8BfAllFSBHiEWuttnG S4CA== Received: by 10.68.239.164 with SMTP id vt4mr42329737pbc.166.1339954312528; Sun, 17 Jun 2012 10:31:52 -0700 (PDT) Received: from [192.168.1.104] (c-69-181-249-16.hsd1.ca.comcast.net. [69.181.249.16]) by mx.google.com with ESMTPS id oo6sm20847783pbc.22.2012.06.17.10.31.51 (version=SSLv3 cipher=OTHER); Sun, 17 Jun 2012 10:31:51 -0700 (PDT) Message-ID: <1339954313.19023.7.camel@jdavis> Subject: Re: [PATCH] Support for foreign keys with arrays From: Jeff Davis To: Simon Riggs Cc: Misa Simic , Gabriele Bartolini , PostgreSQL-development , Marco Nenciarini Date: Sun, 17 Jun 2012 10:31:53 -0700 In-Reply-To: References: <-405928980722608358@unknownmsgid> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.2.2- Content-Transfer-Encoding: 7bit Mime-Version: 1.0 X-Gm-Message-State: ALoCoQnfGcxjZE+eoM2xA6TtsDXpEpmBY3u/HXBnwcTImLQxqxVQX7uNZxpWh0IFHL6DSHgyKCSv X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201206/848 X-Sequence-Number: 209688 On Sun, 2012-06-17 at 21:10 +0800, Simon Riggs wrote: > Do we need something like Exclusion FKs? i.e. the FK partner of > Exclusion Constraints? Yes, "Inclusion Constraints". I've known we need something like that since I did Exclusion Constraints, but I haven't gotten further than that. Regards, Jeff Davis