Server crash caused by CHECK on child
От
Kovacs Baldvin
Тема
Server crash caused by CHECK on child
Дата
Msg-id
Pine.GSO.4.33.0109241000560.5647-100000@ural2
Список
Дерево обсуждения
Server crash caused by CHECK on child Kovacs Baldvin <kb136@hszk.bme.hu>
Re: Server crash caused by CHECK on child Kevin Way <kevin.way@overtone.org>
Re: Server crash caused by CHECK on child Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] Server crash caused by CHECK on child Stephan Szabo <sszabo@megazone23.bigpanda.com>
-- Hi Kevin, and everyone! -- -- I don't think that I only found a minor bug compared to -- the other you wrote in your last letter: the backend crash -- is caused by the same CHECK constraint in the child table. -- -- However, for you without time to analyzing Kevin's huge -- scheme, here is the very simplified, crash-causing script. -- ------------------------------------ drop table child; drop table ancestor; create table ancestor ( node_id int4, a int4 ); create table child ( b int4 NOT NULL DEFAULT 0 , c int4 not null default 3, CHECK ( child.b = 0 OR child.b = 1 ) ) inherits (ancestor); insert into ancestor values (3,4); insert into child (node_id, a, b) values (5,6,1); update ancestor set a=8 where node_id=5; --------------------------------- -- -- I am hunting it, but I have to learn all what this query-executing -- about, so probably it takes uncomparable longer for me than for -- a developer. -- -- Regards, -- Baldvin --
В списке pgsql-sql по дате отправления
От: Oleg Bartunov
Дата: