unique across two tables

Поиск
Список
Период
Сортировка
От Tarlika Elisabeth Schmitz
Тема unique across two tables
Дата
Msg-id 20110620160307.683ab611@dick.coachhouse
обсуждение исходный текст
Ответы Re: unique across two tables
Re: unique across two tables
Re: unique across two tables
Список pgsql-general
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?



=========
PostgreSQl 8.4

CREATE TABLE town
(
  country_fk character varying(3) NOT NULL,
  region_fk character varying(3) NOT NULL,
  id serial NOT NULL,
  "name" character varying(50) NOT NULL
)

CREATE TABLE townalias
(
  country_fk character varying(3) NOT NULL,
  region_fk character varying(3) NOT NULL,
  town_fk integer NOT NULL,
  id serial NOT NULL,
  "name" character varying(50) NOT NULL,
  CONSTRAINT town_townalias_fk FOREIGN KEY (country_fk, region_fk,
town_fk) REFERENCES town (country_fk, region_fk, id)
)

--

Best Regards,
Tarlika Elisabeth Schmitz

В списке pgsql-general по дате отправления:

Предыдущее
От: Marko Kreen
Дата:
Сообщение: Re: PostgreSQL 8.4.8 bringing my website down every evening
Следующее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: unique across two tables