Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    4

    Exclamation Unanswered: Postgres 7.2.1 keep inheritance bugs !!!

    Be carefull of the new version of postgres !!!!

    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 !!!!

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    Bug

    this bug is known
    It's discussed in the hackers mailing list
    and will be fixed soon as I expect
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •