Thread: Query string is too long

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

Dino Nardini <dino@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