Re: Many to many link tables with history?

From: skinner(at)britvault(dot)co(dot)uk (Craig R(dot) Skinner)
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Many to many link tables with history?
Date: 2013-10-10 20:23:07
Message-ID: 20131010202307.GA2423@teak.britvault.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dylan Sanders 2013-10-10 20:25:19 Re: Many to many link tables with history?
Previous Message Gary Stainburn 2013-10-10 11:03:33 Re: generate a range within a view