| From: | stephane parenton <stephane(at)parenton(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | unique heritage |
| Date: | 2003-09-05 13:11:37 |
| Message-ID: | 3F588B89.1040307@parenton.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi everyone,
I'm trying to understand the heritage with postgres....
I have a table called iface with (Physik macaddr UNIQUE, logik cidr)
and another table called komputer with (OS varchar(50)) inherits (iface)
I logically have komputer with OS, physik and logik)... But what i don't
get is why physik in komputer is no more unique, while it's still is in
iface.... All attributes aren't inherited then ?... i thought i saw the
same thing about IDs (and serial), but as ID are not necessary
everywhere, i did not bother)... but here, in this example (and in my
real DB) there is a problem because i can enter serveral time the same
mac adress... and i shouldn't !
Thanks for any tips....
Stephane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bjørn T Johansen | 2003-09-05 13:23:24 | Re: [PERFORM] Seq scan of table? |
| Previous Message | Marc G. Fournier | 2003-09-05 13:03:15 | Re: YOUR SITES SEARCH FEATURE DOES NOT WORK! |