Quick Links

Re: child table doesn't inherit PRIMARY KEY?

From:	Peter Eisentraut <peter_e(at)gmx(dot)net>
To:	ldm(at)apartia(dot)com
Cc:	pgsql-general(at)postgresql(dot)org
Subject:	Re: child table doesn't inherit PRIMARY KEY?
Date:	2000-06-04 01:46:53
Message-ID:	Pine.LNX.4.21.0006040341030.348-100000@localhost.localdomain
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
Thread:
Lists:	pgsql-docs pgsql-general pgsql-hackers

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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

child table doesn't inherit PRIMARY KEY? at 2000-06-03 15:22:56 from Louis-David Mitterrand

Responses

Re: child table doesn't inherit PRIMARY KEY? at 2000-06-04 07:20:16 from Louis-David Mitterrand
Re: child table doesn't inherit PRIMARY KEY? at 2000-10-02 16:29:34 from Bruce Momjian
Generating HISTORY file at 2000-12-16 20:15:26 from Bruce Momjian
Re: child table doesn't inherit PRIMARY KEY? at 2001-01-19 04:57:07 from Bruce Momjian

Browse pgsql-docs by date

	From	Date	Subject
Next Message	Louis-David Mitterrand	2000-06-04 07:20:16	Re: child table doesn't inherit PRIMARY KEY?
Previous Message	Peter Eisentraut	2000-06-03 22:44:26	Re: Documentation of configuration settings

Browse pgsql-general by date

	From	Date	Subject
Next Message	Louis-David Mitterrand	2000-06-04 07:20:16	Re: child table doesn't inherit PRIMARY KEY?
Previous Message	Peter Eisentraut	2000-06-04 01:46:46	Re: Any monitor programs?

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Lamar Owen	2000-06-04 02:03:03	Re: config files in /data
Previous Message	Peter Eisentraut	2000-06-04 01:46:01	Re: config files in /data