Max size of a TEXT field
От | Ing. Ivo Schwarzer |
---|---|
Тема | Max size of a TEXT field |
Дата | |
Msg-id | 3AF13443.8463.14FAB4@localhost обсуждение исходный текст |
Список | 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@spilimbergo.com
В списке pgsql-odbc по дате отправления: