Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37504=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1VUMlQ-0000pC-7E
 for pgsql-sql@arkaria.postgresql.org; Thu, 10 Oct 2013 20:23:16 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37504=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1VUMlP-0003km-JN
 for pgsql-sql@arkaria.postgresql.org; Thu, 10 Oct 2013 20:23:15 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <skinner@britvault.co.uk>) id 1VUMlO-0003kf-GX
 for pgsql-sql@postgresql.org; Thu, 10 Oct 2013 20:23:14 +0000
Received: from teak.britvault.co.uk ([78.33.153.148])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <skinner@britvault.co.uk>) id 1VUMlK-0001pK-Sj
 for pgsql-sql@postgresql.org; Thu, 10 Oct 2013 20:23:13 +0000
Received: by teak.britvault.co.uk (Postfix, from userid 1970)
 id 3cwkJD0dvVzBFj; Thu, 10 Oct 2013 21:23:08 +0100 (BST)
Date: Thu, 10 Oct 2013 21:23:07 +0100
To: pgsql-sql@postgresql.org
Subject: Re: Many to many link tables with history?
Message-ID: <20131010202307.GA2423@teak.britvault.co.uk>
References: <20131008170415.GA29813@teak.britvault.co.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20131008170415.GA29813@teak.britvault.co.uk>
User-Agent: Mutt/1.5.21 (2010-09-15)
From: skinner@britvault.co.uk (Craig R. Skinner)
X-Pg-Spam-Score: 0.6 (/)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 2013-10-08 Tue 18:04 PM |, Craig R. Skinner wrote:
> Hi folks, I'm new here. I hope this is the correct list....
> 
> While creating a database of customer subscribed services with
> DNS domains, I want to:
> *) enable customers to subscribe to multiple services
> *) each service can have multiple domain names per customer
> *) a domain name must be unique per customer per timestamp
> 

Probably (!!) solved by using a tstzrange exclusion constraint:
http://dba.stackexchange.com/questions/51280/many-to-many-link-tables-with-history



-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql