Re: Inheritance and shared sequence

Sebastjan Trepca wrote:
> 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?

Well, if you *always* use the sequence you'll be OK (until you run out
of numbers), but it won't stop you manually supplying your own values.

--
   Richard Huxton
   Archonet Ltd