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
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 |