Inheriting Primary Keys

Поиск
Список
Период
Сортировка
От Dan Linderman
Тема Inheriting Primary Keys
Дата
Msg-id 005001bf4afa$f97d6f90$e68ca8c0@eng.ironhilltech.com
обсуждение исходный текст
Список pgsql-sql
A coworker recently was playing with inheritance in PostgreSQL, and noticed
that Primary Keys were not inhetited by child tables.  He created a parent
table with a Primary Key, then created a tabel to inhetir the parent, but
the unique constraint of the primary key was not passed on.  Is this a known
occurance?  If so, how do we enforce the uniqueness of the inherited column?

Dan Linderman
Web Programmer
Iron Hill Technology
linderdm@ironhilltech.com
302-369-9750 x23
www.ironhilltech.com



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

Предыдущее
От: Liliana Pineda
Дата:
Сообщение: soporte
Следующее
От: "Dan Linderman"
Дата:
Сообщение: Trigger tables