Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: child table doesn't inherit PRIMARY KEY?
Date
Msg-id Pine.LNX.4.21.0006040341030.348-100000@localhost.localdomain
Whole thread Raw
In response to child table doesn't inherit PRIMARY KEY?  (Louis-David Mitterrand <cunctator@apartia.ch>)
Responses Re: child table doesn't inherit PRIMARY KEY?  (Louis-David Mitterrand <cunctator@apartia.ch>)
Re: child table doesn't inherit PRIMARY KEY?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: child table doesn't inherit PRIMARY KEY?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
Louis-David Mitterrand writes:

> 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?

It's kind of a bug.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Problems with Large Databases
Next
From: Louis-David Mitterrand
Date:
Subject: Re: child table doesn't inherit PRIMARY KEY?