Inheriting Primary Keys - Mailing list pgsql-sql

From Dan Linderman
Subject Inheriting Primary Keys
Date
Msg-id 005001bf4afa$f97d6f90$e68ca8c0@eng.ironhilltech.com
Whole thread Raw
List 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 by date:

Previous
From: Liliana Pineda
Date:
Subject: soporte
Next
From: "Dan Linderman"
Date:
Subject: Trigger tables