Markus Wollny wrote:
>
> Are there any known issues concerning persistant connections apart from
> the pgpconnect-thingy with PHP? Is anyone running the same combination
> of *nix/Postgres+IIS/ColdFusion?
PostgreSQL 7.1 on i386-unknown-openbsd2.9, compiled by GCC 2.95.3
ColdFusion 4.5.1 SP2 on Windows NT 4 SP6a, ODBC 7.01.00.06
But it is all super light load, all the queries return 1 row or they are
cached on the ColdFusion side. Only issue I ever had was that I needed
to explicitly cast text columns to varchar or else the query would
return an error (which I have been unable to reproduce with later ODBC
drivers).
If you are running CF MX, try the JDBC driver. I haven't finished
testing it, but so far it is looking good.
Jochem
--
Jochem van Dieten
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/