Test platform = Win 2000 plus all service packs, hotfixes. No previous PostgreSQL ever installed on the machine before.
8.0.0 beta 5 installation executable from http://pgfoundry.org/projects/pginstaller Installed NOT AS A SERVICE, repeat NOT as a WinNT/2K service. Told installer to put installation in C:\PostgreSQL\8.0.0-beta5\* but almost everything went instead to C:\Program Files\PostgreSQL\8.0.0-beta5\* The installer script seems "hard wired" to use "Program Files" folder. This is a bug. The only files that were put into the specified folder were C:\PostgreSQL\8.0.0-beta5\bin\ecpg.exe C:\PostgreSQL\8.0.0-beta5\include\*.h (C header files) C:\PostgreSQL\8.0.0-beta5\lib\(*.dll | *.a) (dev stuff) While everything else went into C:\Program Files\PostgreSQL\8.0.0-beta5\* ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match