child table doesn't inherit PRIMARY KEY? - Mailing list pgsql-general

From Louis-David Mitterrand
Subject child table doesn't inherit PRIMARY KEY?
Date
Msg-id 20000603172256.A3435@styx
Whole thread Raw
Responses Re: child table doesn't inherit PRIMARY KEY?  (Louis-David Mitterrand <cunctator@apartia.ch>)
Re: child table doesn't inherit PRIMARY KEY?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
When creating a child (through CREATE TABLE ... INHERIT (parent)) it
seems the child gets all of the parent's contraints _except_ its PRIMARY
KEY. Is this normal? Should I add a PRIMARY KEY(id) statement each time
I create an inherited table?

Cheers,

--
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.fr

If at first you don't succeed, redefine success.

pgsql-general by date:

Previous
From: Giles Lean
Date:
Subject: Re: Industrial-Strength Logging
Next
From: Kari Lempiainen
Date:
Subject: Any monitor programs?