On Wed, Jul 06, 2005 at 05:44:44PM -0400, Bruce Momjian wrote: > felix@xxxxxxxxxxx wrote: > > > > Could a corrupt db cause these mood swings? And if so, would that > > persist even across dropdb / creatdb? > > Yes, that is possible, but usually it would fail consistently. Have you > run memtest and disk diagnostics? I moved the disks to a new machine, same problem, which doesn't rule out disk problems. We were getting a second machine ready for testing this problem, but my boss has decided to upgrade to 8.0.3 tonight for himself, and probably very soon after for the rest of us, and the problem is in the work mood right now, so we will no doubt follow the general principle of changing many things at once to make tracking things down more fun :-) -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket surgeon / felix@xxxxxxxxxxx GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org