Hey folks,
I've been migrating a content management system from MS SQL Server 7 over
to PostgreSQL. I used the EMS DataPump utility
(http://www.ems-hitech.com/index.phtml) to migrate the database, but
noticed that in the process it truncated a few large text blocks. I then
plugged the ColdFusion web application into the PG database and ran into
problems trying to insert large text blocks into the database. Error as
follows:
"Error while executing the query; Query string is too long"
The entry fields are set to "text" datatype, so should easily handle the
web page content. I'm thinking that the problem may be related to the
driver. The content management system manages pages of text on client
websites. A query string limitation wouldn't go over well with the
clients, heh :)
I'm wondering if the problem is related to the outdated unixODBC driver
that was included with ColdFusion 5, or perhaps there is a setting that I
am overlooking in PG? The fact that the EMS DataPump truncated the large
text causes some concern.
I've also posted a similiar message in the ColdFusion Forum at the
Macromedia site.... and I'm just now compiling the latest unixODBC
driver. I have a test box that I can play around with. I'm hoping to
replace the current unixODBC driver that was included with CF 5 with the
latest driver. Hope for the best :)
For the record, I'm running ColdFusion 5 and PostgreSQL 7.4.1 on a (heavily
patched) RH 7.2 box.
Any suggestions would be greatly appreciated.
Sadly, my Friday nights have been reduced to this... ha :)
Cheers... Dino
_____________________________________
Rivendell Software - Dynamic Web Solutions
http://www.rivendellsoftware.com
Tel 902.461.1697
Fax 902.461.3765