| 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: | Whole Thread | Raw Message | 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 |