On Apr 19, 2005, at 1:01 AM, Tom Lane wrote:
Lorenzo Thurman <lorenzo@xxxxxxxxxxxxxxx> 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
Tech/Library Combo Lab Manager Northwestern University Office Tech MG49 mailto:lthurman@xxxxxxxxxxxxxxxx voice: 847-467-6565 pager: 847-536-0094
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org