Postgres Problems

[Chris Lyman]

Hi All,

I'm posting this in case somebody else has the same problem.

With CF 7 (I'm using Red Hat 9, I don't know about other platforms): after
you restart the server, if the first page that is requested from the server
is a page that makes a call to the Postgres JDBC driver AND you have
debugging turned on, you'll get a 500 error saying something like 'Error
Executing Database Query'. And then from the point on all your debugging
information will be overwritten with the error message, even if you're on a
page that doesn't make a database call. Even if you restart the server the
error will still show up.

The cure (at least for me): go in and move the JDBC driver out of the CF
class path. Restart the server and call a non database calling page, your
debug information should come back. Move the JDBC driver back in, restart
the server. Make a call to the non-database page, make sure your debug
information is there. Cross your fingers and make a call to the database
page, your debug information should be back and all should be right with the
universe.


--
Best Regards,
Chris

[Symantec]

Ive been using coldfusion and postgres with resin3 on freebsd and have had
also noticed that the first call to the postgres database fails but every call
after that is fine. Although I do not use debugging so I am not sure if the
output is affected.