unique heritage

Поиск
Список
Период
Сортировка
От stephane parenton
Тема unique heritage
Дата
Msg-id 3F588B89.1040307@parenton.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "shreedhar"
Дата:
Сообщение: How can I set postmaster as a service
Следующее
От: "Relaxin"
Дата:
Сообщение: Re: Optimizer picks an ineffient plan