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@fr.netcentrex.net
