Skip site navigation (1) Skip section navigation (2)

Re: Server crash caused by CHECK on child

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackerspgsql-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;


In response to

Responses

pgsql-hackers by date

Next:From: Kevin WayDate: 2001-09-24 16:11:48
Subject: Re: Bug?: Update on ancestor for a row of a child
Previous:From: Stephan SzaboDate: 2001-09-24 16:07:31
Subject: Re: [SQL] outer joins strangeness

pgsql-bugs by date

Next:From: Kevin WayDate: 2001-09-24 16:18:10
Subject: Re: [HACKERS] Server crash caused by CHECK on child
Previous:From: Peter EisentrautDate: 2001-09-24 13:01:06
Subject: Re: Bug #468: psql field separator......

pgsql-sql by date

Next:From: Josh BerkusDate: 2001-09-24 16:10:27
Subject: Re: How to enter lists into database:Example.
Previous:From: Stephan SzaboDate: 2001-09-24 16:07:31
Subject: Re: [SQL] outer joins strangeness

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group