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@xxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
