Postgres Pro
Downloads
Home   >   mailing lists

Re: Many to many link tables with history? - Mailing list pgsql-sql

From skinner@britvault.co.uk (Craig R. Skinner)
Subject Re: Many to many link tables with history?
Date
Msg-id 20131010202307.GA2423@teak.britvault.co.uk
Whole thread Raw
In response to Many to many link tables with history?  (skinner@britvault.co.uk (Craig R. Skinner))
Responses Re: Many to many link tables with history?  (Dylan Sanders <soe219@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: generate a range within a view
Next
From: Dylan Sanders
Date:
Subject: Re: Many to many link tables with history?