Skip site navigation (1) Skip section navigation (2)

Max size of a TEXT field

From: "Ing(dot) Ivo Schwarzer" <schwarzer(at)bugnion(dot)it>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Max size of a TEXT field
Date: 2001-05-03 08:34:43
Message-ID: 3AF13443.8463.14FAB4@localhost (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

I am quite new to Postgres. 
My problem arises while UPDATING a record containing a text field 
if the length of it is > 8190 characters.

I use Postrgres 7.1 (RedHat 6.2, RPM version) and version 
07.01.0004 of the Odbc driver, Ado and VB6. 
The driver settings are:

Text as LongVarChar=yes
Unknowns as LongVarChar=no
Max LongVarChar=8190

If I try to increment MaxLongVarChar to values > 8190 Ado reports 
errors even while updating short or empty TEXT fields.

This is the error that I get if I use pgAdmin to insert a new record 
with a very long TEXT field:

.* pgAdmin v7.1.0: Error - 2001-05-03 09.49.20
Error Details
Error Number: -2147024882
Error Description: Memoria esaurita
Error Source: pgAdmin
Subroutine of Function: frmSQLOutput, 

System Details
Operating System: Windows 98 v4.10 Build 2222
Additional Info: A 

Environment Details
Application Path: C:\PROGRAMMI\PGADMIN
Datasource: PostgreSQL
Tracking: Falso
TrackVer: 0
Connect: Provider=MSDASQL.1;Extended 
MDAC Version: 2.6
DBMS Version: 07.01.0004 PostgreSQL 7.1 on i686-
pc-linux-gnu, compiled by GCC egcs-2.91.66


E-mail: ivo(at)spilimbergo(dot)com

pgsql-odbc by date

Next:From: Tom.BakkenDate: 2001-05-03 22:09:00
Subject: MS Access97 Postgres ODBC problems
Previous:From: Dave PageDate: 2001-05-02 14:32:13
Subject: RE: ODBC changes

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group