Re: Old problem needs solution

On Fri, 3 Jun 2005 12:38 am, Tom Lane wrote:
> "Gerald D. Anderson" <gander(at)vte(dot)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
>
>