Evidently the software you're using to connect to/interface with PostgreSQL
have these limits, not PostgreSQL itself... The only thing that I see you
can do is contact the authors of the software and inform them of the
problem...
-Mitch
---- Original Message -----
From: "Frank Hilliard" <frankhilliard@home.com>
To: <pgsql-general@postgresql.org>
Sent: Monday, June 25, 2001 1:03 PM
Subject: [GENERAL] Storage limits in PostgreSQL?
> I'm running into quite severe limits going into and out of PostgreSQL.
> At first I was getting the "text string is too long" error message in
> PostgreSQL. Then I upgraded to version 7.1 and that stopped. However, I
> still got it in Cold Fusion Linux. Today I tried a test block of text
> and measured where the cutoffs are. Here's the results:
>
> ACTION: copy 109,128 characters into a phpPgAdmin "Edit" text entry box.
>
> RESULT: phpPgAdmin cuts off the copy at 28,652 characters [no more
> accepted in box]
> UPDATE EMPTY text cell:
> RESULT: accepted [that is, it accepted 28,652 characters]
> QUERY cell with Cold Fusion
> RESULT: 7,995 characters displayed.
>
> Cold Fusion has an option called "Accept long text string" which is
> checked in CF administrator. I can also set the number of characters as
> high as 999,999. There can't be a low limit in the amount I can copy
> because
> I can copy over 700,000 characters locally.
>
> Any help or suggestions would be greatly appreciated.
>
> Frank Hilliard
> http://frankhilliard.com/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
