Can a field be a primary key as well as a foreign key? - Mailing list 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
);