Re: Server crash caused by CHECK on child

From: Kevin Way <kevin(dot)way(at)overtone(dot)org>
To: Kovacs Baldvin <kb136(at)hszk(dot)bme(dot)hu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Server crash caused by CHECK on child
Date: 2001-09-24 11:42:33
Message-ID: 20010924114233.A76269@bean.overtone.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Way 2001-09-24 11:49:36 Crash caused by CHECK on child
Previous Message Hans-Juergen Schoenig 2001-09-24 10:19:12 Re: Vacuums and bad process status

Browse pgsql-hackers by date

  From Date Subject
Next Message Patrick Welche 2001-09-24 14:12:39 Re: anoncvs failure...
Previous Message Niall Litchfield 2001-09-24 11:39:56 Re: NewYork Bombing: SQL server bomb proof!!

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-09-24 15:07:30 Re: How to enter lists into database.
Previous Message meghana mande 2001-09-24 09:27:50 Problem in connection using .odbc.ini