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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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