Thread: Can not input large text data

The text field type is limited by the segment size (8K you can change and
recompled for 32K). If you need to store more than 32K you need to use blob data
field.

Best regards,
Ngoc-Khoi TO.

---------------------- Envoyée par Tô Ngoc-Khoi/BPF/BIE/VNU le 18/10/2001 17:10
---------------------------


qk22@gmx.co.uk (qk22) le 17/10/2001 21:33:50

Pour :    pgsql-general@postgresql.org
cc :   (ccc : Tô Ngoc-Khoi/BPF/BIE/VNU)
Objet :   [GENERAL] Can not input large text data



I am using PostgreSQL 7.1.3. I found that I can not input text data
for more than 7MB. When I tried to input text data more than about
7MB, I got the error message:" Network error: Connect reset by peer).
I don't know why.
Can anybody help me with the problem?

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Hi

> -----Original Message-----
> From: qk22@gmx.co.uk [mailto:qk22@gmx.co.uk]
> Subject: [GENERAL] Can not input large text data
>
> I am using PostgreSQL 7.1.3. I found that I can not input text data
> for more than 7MB. When I tried to input text data more than about
> 7MB, I got the error message:" Network error: Connect reset by peer).
> I don't know why.
> Can anybody help me with the problem?

You have to at least tell us how you're connecting to the server.  Are you using plsql?  Are you using jdbc?  php?

Roy.

t.ngockhoi@bpf.vnu.com writes:

> The text field type is limited by the segment size (8K you can
> change and recompled for 32K). If you need to store more than 32K
> you need to use blob data field.

This is completely wrong as of 7.1.X, which the original poster is
using.  Tuples can be very large in recent versions.  So whatever is
wrong, it isn't that.  ;)

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863