unique across two tables

Поиск
Список
Период
Сортировка
Искать
От
Tarlika Elisabeth Schmitz
Тема
unique across two tables
Дата
Msg-id
20110620160307.683ab611@dick.coachhouse
Список
Дерево обсуждения
Re: unique across two tables Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: unique across two tables Tarlika Elisabeth Schmitz <postgresql4@numerixtechnology.de>
Re: unique across two tables Gavin Flower <GavinFlower@archidevsys.co.nz>
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
Дата:
От: tv@fuzzy.cz
Дата:
Сообщение: Re: unique across two tables
FAQ