Inherited tables, indexes and serials. - Mailing list pgsql-general

From DaVinci
Subject Inherited tables, indexes and serials.
Date
Msg-id 20001017135356.A1859@fangorn.net
Whole thread Raw
Responses Re: Inherited tables, indexes and serials.  (Nico D <nico@mclink.it>)
List 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

pgsql-general by date:

Previous
From: "chris markiewicz"
Date:
Subject: do triggers/procedures run instantly?
Next
From: "Warren Flemmer"
Date:
Subject: A better stop