Bborie,
I apologize for the waste of time. I figured out what is different about my 8.4.
I had an extra line in my Pg 8.4 database launch script that had:
@SET GDAL_DATA=C:\projects\gdal\rel-trunk\share\gdal
That folder has a bunch of transform csv files. It was alsoo at a time when I rebuilt GDAL so could also be a permission issue with that folder.
and it was giving errors like the below in the log when transform was done
ERROR 6: Unable to load PROJ.4 library ("libproj.dll"), creation of
OGRCoordinateTransformation failed.
Not sure why that line even matters unless they are proj 4.7 specific files and somehow force proj to override its standard behavior.
Anyrate we didn't have it in our 9.0 and 9.1 pg launch scripts. Once I got rid of that line all worked fine. I'm not sure though what happens if people have that in their global environment variables. They might run into the same issues I suppose as I think PostgreSQL pays attention to environment variables.
