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 or flat)
Thread:
Lists: pgsql-odbc
Hi,

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
MaxVarchar=254
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, 
cmdSave_Click

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 
Properties="DSN=PostgreSQL;DATABASE=db_prova;SERV
ER=172.16.16.205;PORT=5432;UID=postgres;PWD=*****
*;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDC
OLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSE
TTINGS="
MDAC Version: 2.6
DBMS Version: 07.01.0004 PostgreSQL 7.1 on i686-
pc-linux-gnu, compiled by GCC egcs-2.91.66


Thanks, 
Ivo

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-2014 The PostgreSQL Global Development Group