By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,693 Members | 1,972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,693 IT Pros & Developers. It's quick & easy.

Query string is too long

P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Dino Nardini <di**@rivendellsoftware.com> writes:
"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.
There is (pretty much) no query size limit in modern versions of PG.
It used to be 8k or so, and some old drivers still try to enforce that
limit in order to avoid database errors.
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 :)
Sounds like the best approach--good luck.
Sadly, my Friday nights have been reduced to this... ha :)


I feel your pain--I just got back from 12+ hours at work doing a
software upgrade...

-Doug

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.