unique heritage - Mailing list pgsql-general

From stephane parenton
Subject unique heritage
Date
Msg-id 3F588B89.1040307@parenton.com
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: "shreedhar"
Date:
Subject: How can I set postmaster as a service
Next
From: "Relaxin"
Date:
Subject: Re: Optimizer picks an ineffient plan