Yup, was just going to respond this morning. It isn't enabled by
default (at least in the ebuilds I've looked at). I've built it with
pg_hier and without pg_hier and get the same results either way : /
Might there be some other cause for this? Or even a dirty fix if this
is what it is?
Gerald
Russell Smith wrote:
>On Fri, 3 Jun 2005 12:38 am, Tom Lane wrote:
>
>
>>"Gerald D. Anderson" <gander@vte.com> writes:
>>
>>
>>>So, the plot thickens. Is there somewhere I can go tweak a few bytes to
>>>make it think it's 7.3?
>>>
>>>
>>No. That's not what you want anyway; you want a late 7.4 build, just
>>one without the hierarchical-queries patch. I dunno enough about Gentoo
>>to say how you get rid of a patch you don't want, but if it's anything
>>like RPMs, you can just dike the patch out of the specfile and rebuild.
>>
>>
>>
>USE="-pg-hier" emerge -vp =postgresql-7.4.7-r2
>
>Will do the job on gentoo. It's not enabled by default unless somebody has put
>pg-hier somewhere in the use flags.
>
>Regards
>
>Russell Smith
>
>
>
>
>
>> regards, tom lane
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 9: the planner will ignore your desire to choose an index scan if your
>> joining column's datatypes do not match
>>
>>
>>
>>
>
>
>