Inherited tables, indexes and serials.

From: DaVinci <bombadil(at)wanadoo(dot)es>
To: Lista PostgreSql <pgsql-general(at)postgresql(dot)org>
Subject: Inherited tables, indexes and serials.
Date: 2000-10-17 11:53:56
Message-ID: 20001017135356.A1859@fangorn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.

When I create a table that inherits a serial field from another, the unique
index is created and used for parent but not for child. OTOH, serial can be
used by both tables. So, child desn't check by default for unique values.

My problem with that is conceptual. Is it normal? Do I must create index for
child? Where is then transparency of object orientedness?.

Greets. Excuse my poor english.

David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Warren Flemmer 2000-10-17 12:00:35 A better stop
Previous Message chris markiewicz 2000-10-17 11:37:33 do triggers/procedures run instantly?