Re: Query string is too long

Dino Nardini <dino(at)rivendellsoftware(dot)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