Can a field be a primary key as well as a foreign key?

Поиск
Список
Период
Сортировка
От Andrew Snow
Тема Can a field be a primary key as well as a foreign key?
Дата
Msg-id 20020312154409.B397@esper.modulus.org
обсуждение исходный текст
Ответы Re: Can a field be a primary key as well as a foreign key?  (Jan Wieck <janwieck@yahoo.com>)
Список pgsql-general

Can anyone see any problem with the following, practice?


CREATE TABLE parent (
  foo SERIAL PRIMARY KEY
);

CREATE TABLE child (
  foo INTEGER PRIMARY KEY REFERENCES parent ON DELETE CASCADE,
  bar TEXT
);

CREATE TABLE subchild (
  foo INTEGER PRIMARY KEY REFERENCES child ON DELETE CASCADE,
  bar2 TEXT
);


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_toast table growth out of control
Следующее
От: Francisco Reyes
Дата:
Сообщение: Re: spanish characters in postgresql