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@spilimbergo.com
