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

Still Inheritance Bugs with postgres 7.2.1

From: Alban Médici <amedici(at)fr(dot)netcentrex(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Still Inheritance Bugs with postgres 7.2.1
Date: 2002-04-19 16:08:59
Message-ID: 3CC0411B.9090009@fr.netcentrex.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Some inheritances bugss are fiked but not all !!!!

In the New version of postgresSQL (7.2.1) inheritance bug was fixed.
Now SQL99 is respect for simple inheritance behavior.

// Example :

create table people( id INT UNIQUE, name VARCHAR);
create table mother( nb_son INT) INHERITS(people);
create table house (id INT UNIQUE, nbFloor INT, ownerID INT REFERENCES 
"people"("id"));

insert into mother VALUES (1,'first mum',0);
insert into mother VALUES (2,'second mum',3);

DB=# select * from mother ;
id | name | nb_son
----+------------+--------
1 | first mum | 0
2 | second mum | 3
(2 rows)

 OK


DB=# select * from people ;
id | name
----+------------
1 | first mum
2 | second mum
(2 rows)

 OK

now test if respect SQL99
DB=# select id from people where name='second mum';
id
----
2
(1 row)

 Ouah !! One bug Fix !!!! cool

// Now the references test ( humhum suspens ...... ;-) )

DB=# insert into house values (1,3,2);
ERROR: <unnamed> referential integrity violation - key referenced f

meens that value id=2 don't exist in people table !!!!!

Non Fix Bug !!!!

-- 
Alban Médici
R&D Software Engineer
tel: +33 (0)2 31 46 35 80 (+005)
--------------------------------
http://www.netcentrex.net
amedici(at)fr(dot)netcentrex(dot)net



pgsql-bugs by date

Next:From: Dmitry TkachDate: 2002-04-19 17:31:43
Subject: Patch for memory leaks in index scan
Previous:From: pgsql-bugsDate: 2002-04-19 15:57:48
Subject: Bug #636: REFERENCES on Inherits Table

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