On Tue, 6 Jun 2006, Tom Lane wrote:
Some cursory trawling in the REL7_3 sources says that this means that "SELECT DISTINCT loid FROM pg_largeobject" found a large object OID that then could not be found by an indexscan of pg_largeobject. So I'd try a REINDEX of pg_largeobject to see if that fixes it. See the REINDEX man page concerning hoops you have to jump through to reindex a system catalog --- IIRC, the hoops are much higher and narrower back in 7.3.
Thanks Tom. BTW, you might be amused to see the uptime output prior to shutting the machine down to add a PCI card:
10:17am up 1004 days, 7 min, 1 user, load average: 0.00, 0.00, 0.00 -- Jeff Frost, Owner <[EMAIL PROTECTED]> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
