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.
Primary key not working correctly with inheritance
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 been wasting your time with my newness to postgres.
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: Bruce Momjian||Date: 2002-01-23 15:55:51|
|Subject: Re: Bug #566: Primary key not working correctly with inheritance|
|Previous:||From: pgsql-bugs||Date: 2002-01-23 15:46:20|
|Subject: Bug #565: Primary key not working correctly with inheritance|