From: | Frank Hilliard <frankhilliard(at)home(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Storage limits in PostgreSQL? |
Date: | 2001-06-25 17:03:24 |
Message-ID: | 3B376EDC.B87937C5@home.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Vince Vielhaber | 2001-06-25 17:20:43 | Re: More Red Hat information |
Previous Message | Thalis A. Kalfigopoulos | 2001-06-25 17:02:12 | INNER JOIN ON vs ','+WHERE |