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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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