Re: unique across two tables - Mailing list pgsql-general

From Alban Hertroys
Subject Re: unique across two tables
Date
Msg-id A510C5B4-939B-4D19-8405-AE93C6BCCE9F@solfertje.student.utwente.nl
Whole thread Raw
In response to unique across two tables  (Tarlika Elisabeth Schmitz <postgresql4@numerixtechnology.de>)
Responses Re: unique across two tables  (Tarlika Elisabeth Schmitz <postgresql4@numerixtechnology.de>)
List pgsql-general
On 20 Jun 2011, at 17:03, Tarlika Elisabeth Schmitz wrote:

> I have two tables, town and townalias, the latter containing alternative
> town names.
> I would like to ensure that a town name is unique per
> country-region across the two tables.
>
> Can I do this with a constraint ot do I need to implement the logic via
> trigger?


This is very similar to what was recently discussed in the topic "Constraint to ensure value does NOT exist in another
table?"in this list. 

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4dff868612099297279502!



pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: PostgreSQL 8.4.8 bringing my website down every evening
Next
From: Alexander Farber
Date:
Subject: Re: PostgreSQL 8.4.8 bringing my website down every evening