Another unpleasant surprise using inheritance
От | Darko Prenosil |
---|---|
Тема | Another unpleasant surprise using inheritance |
Дата | |
Msg-id | 200406111411.00602.darko.prenosil@finteh.hr обсуждение исходный текст |
Ответы |
Re: Another unpleasant surprise using inheritance
|
Список | pgsql-hackers |
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 DEFAULT0,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 notpresent 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 !
В списке pgsql-hackers по дате отправления: