From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Kovacs Baldvin <kb136(at)hszk(dot)bme(dot)hu> |
Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, Kevin Way <kevin(dot)way(at)overtone(dot)org> |
Subject: | Re: Server crash caused by CHECK on child |
Date: | 2001-09-24 16:09:48 |
Message-ID: | Pine.BSF.4.21.0109240908330.5229-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers pgsql-sql |
What version are you trying this script on? I'm not
seeing a crash on my 7.2 devel system (and the update occurs).
On Mon, 24 Sep 2001, Kovacs Baldvin wrote:
> -- 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;
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Way | 2001-09-24 16:18:10 | Re: [HACKERS] Server crash caused by CHECK on child |
Previous Message | Peter Eisentraut | 2001-09-24 13:01:06 | Re: Bug #468: psql field separator...... |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Way | 2001-09-24 16:11:48 | Re: Bug?: Update on ancestor for a row of a child |
Previous Message | Stephan Szabo | 2001-09-24 16:07:31 | Re: [SQL] outer joins strangeness |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2001-09-24 16:10:27 | Re: How to enter lists into database:Example. |
Previous Message | Stephan Szabo | 2001-09-24 16:07:31 | Re: [SQL] outer joins strangeness |