Inheritance and shared sequence - Mailing list pgsql-general

From Sebastjan Trepca
Subject Inheritance and shared sequence
Date
Msg-id cd329af80706070120k43307b3bg83627197a1fb088c@mail.gmail.com
Whole thread Raw
Responses Re: Inheritance and shared sequence  (Richard Huxton <dev@archonet.com>)
List 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 by date:

Previous
From: "Alexander Staubo"
Date:
Subject: Re: Looking for Graphical people for PostgreSQL tradeshow signage
Next
From: Dave Page
Date:
Subject: Re: pl/pgsql debuging, was Re: debugging C functions