"Dave Page" <dpage@vale-housing.co.uk> writes:
>> It does? Dave just told us that the standard installer
>> package is built to install into /usr/local/pgsql.
> No, I said it's built into the installer from /usr/local/pgsql (the path
> in the msys dev environment). It actually installs into C:\Program
> Files\PostgreSQL\8.X which is where users run it from.
Hmm ... so the real issue is that pgxs sees the installation directory
as named differently from what it was named during backend build. OK,
that makes this behavior a problem, considering that we nominally
support being able to relocate installations. Not sure what to do
about it though. Perhaps pgxs should be interrogating pg_config for
the various path names instead of assuming it can recompute them?
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
