many columns with references to one table

Поиск
Список
Период
Сортировка
От Andreas Fromm
Тема many columns with references to one table
Дата
Msg-id 3F4B4C7A.8070703@physik.uni-erlangen.de
обсуждение исходный текст
Ответы Re: many columns with references to one table  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: many columns with references to one table  (Dennis Gearon <gearond@fireserve.net>)
Re: many columns with references to one table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

What is the problem with the following table declaration?

CREATE TABLE persons (
  id SERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  bdate DATE,
  address INTEGER REFERENCES addresses,
  phonepriv INTEGER REFERENCES phones,
  phoneday INTEGER REFERENCES phones,
  phonemobil INTEGER REFERENCES phones,
  email INTEGER REFERENCES emails,
  mate INTEGER REFERENCES persons,
  updated DATE NOT NULL
);

My problem is that the references to the phones table do not get
restricted, i.e. I can insert any value in the phone*-fields, while the
references to the other tables are restricted to values that allready
exists. The table declaration of phones should be all right, it has a
primary key defined like every other tables I have. Is there a
restriciton that no more then 1 column may reference an other table?

Regards

Andreas Fromm



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

Предыдущее
От:
Дата:
Сообщение: function restore order
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Linux ready for high-volume databases?