Lorenzo Thurman <lorenzo@thethurmans.com> writes:
> I'm trying that right now. I think there may be mis-match in the build
> settings between upgrades of postgresql. The "USE" settings may be at
> fault:
> - - pg-hier : Enables recursive queries like Oracle's 'CONNECT
> BY' feature.
[ rolls eyes... ] Yup, that's Gentoo all right: throw in random patches
that have been rejected by the upstream developers. Now that I think
about it, this failure is exactly what that patch is known to cause,
because it makes an incompatible change in Query structures and hence
in on-disk view rule representation.
> I think these may have been changed since the original install.
Go back to your prior setting, or even better stop using Gentoo's
hacked-up version. I'm not sure why we even bother to answer support
requests from Gentoo users, when what they are using is not our
software but some randomly-modified variant. I wonder what other
brokennesses Gentoo may be including ...
(Just for the record: I work for Red Hat, which has a rather different
notion of the level of reliability it wants to ship. So take my opinion
with the appropriate grain of salt. But I'm a mite ticked off at the
moment --- you're not the first person to have been bitten by this,
and you likely won't be the last, and I think it's entirely because
Gentoo has such a low quality standard for the patches they ship.)
regards, tom lane