Thread: Inheriting Primary Keys

Inheriting Primary Keys

From
"Dan Linderman"
Date:
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