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

Re: Segfault in 8.0.2beta1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Segfault in 8.0.2beta1
Date: 2005-04-01 19:46:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Michael Fuhr <mike(at)fuhr(dot)org> writes:
> While investigating somebody's question I ran the following query,
> which caused the backend to segfault:

> SELECT * FROM foo WHERE first_date <= now() AND last_date >= now();

> I have to run so I can't put together a test case right now, but
> here's the stack trace:

> #0  convert_timevalue_to_scalar (value=1913, typid=1184) at selfuncs.c:2816
> #1  0x81aa3e5 in convert_to_scalar (value=138003712, valuetypid=1184, scaledvalue=0xbfbfea50, 
>     lobound=1913, hibound=1951, boundstypid=1082, scaledlobound=0xbfbfea58, 
>     scaledhibound=0xbfbfea60) at selfuncs.c:2393

Mumble ... that patch I put in last week doesn't work at all, does it?
Back to the drawing board.

			regards, tom lane

In response to


pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-04-01 23:03:53
Subject: Re: Segfault in 8.0.2beta1
Previous:From: Michael FuhrDate: 2005-04-01 18:07:21
Subject: Segfault in 8.0.2beta1

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