Storage limits in PostgreSQL?

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/

Responses

Browse pgsql-general by date

  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