Inheritance and shared sequence

Поиск
Список
Период
Сортировка
От Sebastjan Trepca
Тема Inheritance and shared sequence
Дата
Msg-id cd329af80706070120k43307b3bg83627197a1fb088c@mail.gmail.com
обсуждение исходный текст
Ответы Re: Inheritance and shared sequence
Список pgsql-general
Hi,

as I understood, when you create a table which inherits some other
table, the constraints and indexes do not go to the child table hence
you have to create a separate ones in there. That means you cannot
depend that you won't have duplicate IDs in both tables. Right?

BUT...what if child table and parent table both use the same sequence
for the primary key. Would the duplication still be an issue?

Thanks, Sebastjan

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

Предыдущее
От: "Alexander Staubo"
Дата:
Сообщение: Re: Looking for Graphical people for PostgreSQL tradeshow signage
Следующее
От: Dave Page
Дата:
Сообщение: Re: pl/pgsql debuging, was Re: debugging C functions