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?
Список 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 по дате отправления: