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

Re: bitmap scan cause core dump 8.1dev

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>,Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: bitmap scan cause core dump 8.1dev
Date: 2005-08-27 18:32:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Sat, 27 Aug 2005, Tom Lane wrote:

> Michael Fuhr <mike(at)fuhr(dot)org> writes:
>> On Sat, Aug 27, 2005 at 10:28:30AM -0400, Tom Lane wrote:
>>> Can you provide a self-contained test case?  The backtrace is
>>> interesting but it's not enough information to find the bug.
>> Here's a simple test case based on what I think Oleg is doing.
> I had assumed this was the same bug as your "bogus varno" failure,
> but actually it was a separate bug in plan reference fixup.  Not sure
> yet that Oleg's original complaint is fixed, but we'll see.

seems, my problem fixed now. Thanks Michael and Tom.

> 			regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match

Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su,
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-08-27 18:33:38
Subject: Doesn't MIPS S_UNLOCK require a SYNC instruction?
Previous:From: Tom LaneDate: 2005-08-27 18:07:47
Subject: Re: bitmap scan cause core dump 8.1dev

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