I never got a reply to this, but I am still seeing it from time to time
- twice today in fact. Any suggestions?
cheers
andrew
Andrew Dunstan wrote:
I am consistently seeing the regression failure shown below on my
Windows machine. See
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=loris&dt=2005-07-07%2013:54:13
================== pgsql.2072/src/test/regress/regression.diffs
===================
*** ./expected/prepared_xacts.out Thu Jul 7 09:55:18 2005
--- ./results/prepared_xacts.out Thu Jul 7 10:20:37 2005
***************
*** 179,189 ****
-- Commit table creation
COMMIT PREPARED 'regress-one';
\d pxtest2
! Table "public.pxtest2"
! Column | Type | Modifiers ! --------+---------+-----------
! a | integer | ! SELECT * FROM pxtest2;
a ---
--- 179,185 ----
-- Commit table creation
COMMIT PREPARED 'regress-one';
\d pxtest2
! ERROR: cache lookup failed for relation 27240
SELECT * FROM pxtest2;
a ---
======================================================================
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
