On Thu, Jun 23, 2005 at 11:08:55AM -0400, Andrew Dunstan wrote:
> I just got this regression failure on Windows:
Maybe it has to do with being unable to drop the relcache file?
> ================== pgsql.2220/src/test/regress/regression.diffs
> ===================
> *** ./expected/prepared_xacts.out Thu Jun 23 10:20:28 2005
> --- ./results/prepared_xacts.out Thu Jun 23 10:45:06 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 27228
> SELECT * FROM pxtest2;
> a
> ---
--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"El Maquinismo fue proscrito so pena de cosquilleo hasta la muerte"
(Ijon Tichy en Viajes, Stanislaw Lem)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
