Martin Pitt <[EMAIL PROTECTED]> writes: > ./configure --libdir=3D/usr/lib/postgresql/8.1/lib --bindir=3D/usr/lib/pos= > tgresql/8.1/bin
> is enough to reproduce the problem. With only --libdir, it works, and > with only --bindir the test suite does not run at all because the > postmaster cannot find $libdir (but that is still justifiable). Try adding --datadir=/usr/lib/postgresql/8.1/share to that. Actually, you'd be best off replacing all three options with --prefix=/usr/lib/postgresql/8.1 because that will make sure that the entire installation is consistent. regards, tom lane ---------------------------(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