| From: | "Dan Linderman" <linderdm(at)ironhilltechnology(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Inheriting Primary Keys |
| Date: | 1999-12-20 15:00:37 |
| Message-ID: | 005001bf4afa$f97d6f90$e68ca8c0@eng.ironhilltech.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)ironhilltech(dot)com
302-369-9750 x23
www.ironhilltech.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Linderman | 1999-12-20 15:02:03 | Trigger tables |
| Previous Message | Vladimir Terziev | 1999-12-20 09:58:10 | Re: [SQL] select with group by problem |