Tom Lane said:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
>> It appears that the dblink regression test defaults to port 5432. I've
>> been trying to get platypus to compile clean on HEAD and 8_0 and it's
>> been failing on dblink.
>
> There are several buildfarm machines failing like this. I think a
> possible solution is for the postmaster to do putenv("PGPORT=nnn") so
> that libpq instances running in postmaster children will default to the
> local installation's actual port rather than some compiled-in default
> port.
>
> This is certainly not without its downsides, but if you are running a
> postmaster at a nondefault port then I think you ought to be aware that
> leaving dblink to choose a default port is a fragile idea.
>
This seems to be my day for getting confused.
If this diagnosis were correct, wouldn't every buildfarm member be failing
at the ContribCheck stage (if they get that far)? They all run on non
standard ports and all run the contrib installcheck suite if they can (this
is required, not optional). So if they show OK then they do not exhibit the
problem.
Also, while the PGPORT=nnnn trick looks sort of OK, we need to check it will
work on Windows - I am far from sure it will.
cheers
andrew
---------------------------(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
