Skip site navigation (1) Skip section navigation (2)

Re: Bug #566: Primary key not working correctly with

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <aid(at)logic(dot)org(dot)uk>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Bug #566: Primary key not working correctly with
Date: 2002-01-23 16:09:21
Message-ID: 20020123080432.O18169-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, 23 Jan 2002 pgsql-bugs(at)postgresql(dot)org wrote:

> Short Description
> Primary key not working correctly with inheritance

This is a well known deficiency with the inheritance system.  Certain
things (primary and foreign keys as an example) don't inherit right now.
For primary key, AFAIK we don't have a real mechanism in place to do
a single primary key over multiple tables, but if you just want child
to be unique across itself (ie, you could insert a 1 in parent and in
child, but not two 1's in child) you can make a unique index across
child(id).


In response to

pgsql-bugs by date

Next:From: Mark RaeDate: 2002-01-24 10:12:05
Subject: Error Restoring Large Database
Previous:From: Bruce MomjianDate: 2002-01-23 15:55:51
Subject: Re: Bug #566: Primary key not working correctly with inheritance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group