| From: | Matt <matthew(dot)berardi(at)weilpublishing(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | inheritance problems |
| Date: | 2002-06-11 16:19:05 |
| Message-ID: | 3D0622F9.1060506@weilpublishing.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I have a very general table, Orders, from which three other tables are
children. Orders has only two columns cid, oid, have primary key(oid,
cid). I want all the children to also have this primary key, and I want
uniqness of the primary key enforced accross all children. this was the
reason I decided to use inheritance, however I can insert the same entry
in two children and then look at the duplicates in the Orders :( is it
possible, and if so, how is it done; to have unique primary keys accross
all the children.
Matthew Berardi
WeilPublishing
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam | 2002-06-11 18:21:05 | Select * (but exclude columns) |
| Previous Message | Olaf Frączyk | 2002-06-11 15:19:55 | Unicode and escaping single quotes |