Inheritance and shared sequence

From: "Sebastjan Trepca" <trepca(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Inheritance and shared sequence
Date: 2007-06-07 08:20:19
Message-ID: cd329af80706070120k43307b3bg83627197a1fb088c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johannes Konert 2007-06-07 08:38:27 Suppress checking of chmod 700 on data-dir?
Previous Message Alexander Staubo 2007-06-07 07:55:39 Re: [GENERAL] Looking for Graphical people for PostgreSQL tradeshow signage