[HACKERS] Another unpleasant surprise using inheritance

[Darko Prenosil]

I think I found bug related to table inheritance (or at least very weird 
behavior). 
Here is simplified example:

        DROP SCHEMA master CASCADE;
        DROP SCHEMA skladisno CASCADE;
        CREATE SCHEMA master;
        CREATE SCHEMA skladisno;

        CREATE TABLE master.analiticki_subjekti (
                id serial NOT NULL PRIMARY KEY,
                naziv varchar(60) NOT NULL UNIQUE
        );

        CREATE TABLE master.partneri(
                djelatnost text,
                napomene text,
                ziro_racun varchar(64)
        ) INHERITS (master.analiticki_subjekti);

        INSERT INTO master.partneri 
                (id,naziv)
        VALUES
                (0,'Fooo');


        CREATE TABLE skladisno.skladista (
                id int8 NOT NULL UNIQUE,
                naziv text NOT NULL,
                id_subjekta int NOT NULL DEFAULT 0,
        FOREIGN KEY (id_subjekta) REFERENCES master.analiticki_subjekti(id) ON DELETE 
RESTRICT ON UPDATE RESTRICT
        );

        INSERT INTO skladisno.skladista(id,naziv,id_subjekta) VALUES (1,'SkladiÅte 
1',0);


Gives error:
        insert or update on table "skladista" violates foreign key constraint "$1"
        DETAIL:  Key (id_subjekta)=(0) is not present in table "analiticki_subjekti".
This is not true, because there is record in master.analiticki_subjekti with 
id set to 0 (this record is inserted into master.partneri), but is clearly 
visible when execute SELECT * FROM master.nalaiticki_subjekti.

Now, if I only change script from:
        INSERT INTO master.partneri 
                (id,naziv)
        VALUES
                (0,'Fooo');
to:
        INSERT INTO master.analiticki_subjekti
                (id,naziv)
        VALUES
                (0,'Fooo');

insert passes without error.

Regards !

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]