Re: Server crash caused by CHECK on child - Mailing list pgsql-sql

From Kevin Way
Subject Re: Server crash caused by CHECK on child
Date
Msg-id 20010924114233.A76269@bean.overtone.org
Whole thread Raw
In response to Server crash caused by CHECK on child  (Kovacs Baldvin <kb136@hszk.bme.hu>)
List pgsql-sql
> -- 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.

Oooh, my bad.  I should run your scripts before assuming I know how
they fail.

> -- However, for you without time to analyzing Kevin's huge
> -- scheme, here is the very simplified, crash-causing script.

Thank you so much for finding this simplified method of crashing
Postgres.  Hopefully somebody can find a fix now.

> -- 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.

That's my problem as well, though your example is vastly easier to
trace than mine.  

-Kevin Way



pgsql-sql by date:

Previous
From: Kovacs Baldvin
Date:
Subject: Server crash caused by CHECK on child
Next
From: "Josh Berkus"
Date:
Subject: Re: How to enter lists into database.