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 7: don't forget to increase your free space map settings