problem with foreign keys
От | Malek Shabou |
---|---|
Тема | problem with foreign keys |
Дата | |
Msg-id | 200011142004.VAA12257@fairuz.nic.fr обсуждение исходный текст |
Список | pgsql-hackers |
Hi,i have a problem with REFERENCES (foreign keys). i have this table: drop table paragraph; create table paragraph (id int4 PRIMARY KEY,label varchar(512),paragraph_next int4 CONSTRAINT paragraph_fk_next REFERENCESparagraph DEFERRABLE INITIALLY DEFERRED,paragraph_priv int4 CONSTRAINT paragraph_fk_priv REFERENCES paragraph DEFERRABLEINITIALLY DEFERRED ); if a excute this statements a recive a CONSTRAINT probleme: begin; insert into paragraph values (1,'par1',null,null); insert into paragraph values (2,'par2',null,1); update paragraph set paragraph_next = 2 where id = 1; end; and then: begin; delete from paragraph; insert into paragraph values (1,'par11',null,null); insert into paragraph values (2,'par22',null,1); update paragraph set paragraph_next = 2 where id = 1; end; i recive: ERROR: paragraph_fk_next referential integrity violation - key in paragraph still referenced from paragraph Regards, ---- Malek Shabou E-mail: Malek.Shabou@nic.fr AFNIC France Tel: +33 1 39 63 50 15 c/o INRIA-Rocquencourt Domaine de Voluceau Fax: +33 1 39 63 55 34 B.P.105 78153 Le Chesnay Cedex
В списке pgsql-hackers по дате отправления: