Re: Storage limits in PostgreSQL?

It sounds like you've ruled PostgreSQL as the problem.  What web server and OS
are you using?  Do either impose any limits on the size of text boxes, the size
of environment variables, etc.?  Can you create a test form with a plain
ColdFusion text box, submit it and have ColdFusion display what you typed in,
having taken the database out of the equation?  If a plain form works and
phpPgAdmin doesn't, you might need to look more closely at phppgadmin.




Frank Hilliard <frankhilliard%home.com@interlock.lexmark.com> on 06/25/2001
01:03:24 PM

To:   pgsql-general%postgresql.org@interlock.lexmark.com
cc:    (bcc: Wesley Sheldahl/Lex/Lexmark)
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)