Bug #565: Primary key not working correctly with inheritance - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #565: Primary key not working correctly with inheritance
Date
Msg-id 200201231546.g0NFkKw67657@postgresql.org
Whole thread Raw
List pgsql-bugs
Adrian Bool (aid@logic.org.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:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #566: Primary key not working correctly with inheritance
Next
From: Bruce Momjian
Date:
Subject: Re: Bug #566: Primary key not working correctly with inheritance