From: | Kovacs Baldvin <kb136(at)hszk(dot)bme(dot)hu> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>, Kevin Way <kevin(dot)way(at)overtone(dot)org> |
Subject: | Server crash caused by CHECK on child |
Date: | 2001-09-24 08:01:43 |
Message-ID: | Pine.GSO.4.33.0109241000560.5647-100000@ural2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers pgsql-sql |
-- 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
--
From | Date | Subject | |
---|---|---|---|
Next Message | Ana Claudia | 2001-09-24 09:28:31 | |
Previous Message | Billy G. Allie | 2001-09-24 06:16:34 | Re: Bug #467: Can't insert a value of 0 (zero) into a Bytea |
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Michel POURE | 2001-09-24 08:53:31 | Re: [HACKERS] UTF-8 support |
Previous Message | Dave Page | 2001-09-24 07:37:20 | Re: [ODBC] UTF-8 support |
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Olenin | 2001-09-24 09:08:51 | How to get BLOB size? |
Previous Message | Oleg Bartunov | 2001-09-24 05:54:11 | Re: loading array_iterator.so does not work with Postgresql |