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

Bug #565: Primary key not working correctly with inheritance

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #565: Primary key not working correctly with inheritance
Date: 2002-01-23 15:46:20
Message-ID: 200201231546.g0NFkKw67657@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Adrian Bool (aid(at)logic(dot)org(dot)uk) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Primary key not working correctly with inheritance

Long Description
Hi,

Just started out with postgres (2 days so far!).  I am intrested in it's inheritance abilities.

I have come across something that seems to be a bug as far as I can make out.

See the simple extract in the example code section.

The second insert should not be allowed as it breaks the primary key's unqiueness.  However postgres allows it's insertion.

If one tries to insert directly into 'parent' the problem does not come about - the second insertion is rejected correctly.

The same applies with the 'unique' constraint - which I think should
also apply to child tables.

This is in Postgres 7.1.3 - standard RedHat 7.1 build.

Hope this is indeed a bug and I've not beening wasting your time with my newness to this.

Regards,

aid



Sample Code
create table parent
  (
  id  integer primary key
  ) ;

create table child
  (
  name  varchar (30)
  ) inherits (parent) ;

insert into child values ( 1, 'Adrian' ) ;
insert into child values ( 1, 'John' ) ;


No file was uploaded with this report


pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-01-23 15:47:35
Subject: Bug #566: Primary key not working correctly with inheritance
Previous:From: Dong MengDate: 2002-01-23 02:18:28
Subject: Create a rule for updating on a view

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