Re: table size

"ccruise" <ccruise@rvamerica.com> writes:

> I have postgres 7.2.  I have a web page that uses coldfusion scripting to
> insert the contents of a form into a table.  One of the items on the form is
> a place to put comments.  To insert the data into the table, I used cold
> fusion's url encode which converts all not alpha text into their hex values.
> IE: spaces gets converted to %20 and so on.  It seemed like a good idea to
> avoid having to attempted to catch for ' or " that may be entered into the
> comment until I got an error saying the query string was too long.  Is there
> a limit in postgres on how long the query string can be?

Not currently.  Make sure you're running PG 7.1 or later and using the
latest ODBC driver.

-Doug
--
Doug McNaught       Wireboard Industries      http://www.wireboard.com/

      Custom software development, systems and network consulting.
      Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...