On Sat, 27 Aug 2005, Tom Lane wrote:
> Michael Fuhr <mike@fuhr.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
>
Regards, Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83