inheritance and primary key

Поиск
Список
Период
Сортировка
От Bernie Huang
Тема inheritance and primary key
Дата
Msg-id 3947F3A9.12BDF72@ec.gc.ca
обсуждение исходный текст
Список pgsql-sql
Hi,

Is primary key similar to 'not null columns with indices'?  The reason I
am asking because I found that when you inherit table B from table A,
the primary key in A won't be inherited to B, but only the columns.

I was wondering how do you inherit a primary key or, even, a foreign
key?  If it's not possible, what are the ways going around it?  (not
null index or...???)

Thanks for your help!


- Bernie

Вложения

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Brian C. Doyle"
Дата:
Сообщение: Outputting the Tables of a database
Следующее
От: Vadim Passynkov
Дата:
Сообщение: Some problem with inet type on PostgreSQL-7.0