Re: unique across two tables

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: unique across two tables
Дата
Msg-id A510C5B4-939B-4D19-8405-AE93C6BCCE9F@solfertje.student.utwente.nl
обсуждение исходный текст
Ответ на unique across two tables  (Tarlika Elisabeth Schmitz <postgresql4@numerixtechnology.de>)
Ответы Re: unique across two tables  (Tarlika Elisabeth Schmitz <postgresql4@numerixtechnology.de>)
Список 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 по дате отправления:

Предыдущее
От: Alexander Farber
Дата:
Сообщение: Re: PostgreSQL 8.4.8 bringing my website down every evening
Следующее
От: Alexander Farber
Дата:
Сообщение: Re: PostgreSQL 8.4.8 bringing my website down every evening