Problems with PostODBC driver

Hi,

I have a database in MS Access 97 which I want to port to PostgreSQL.
The database has rather large text fields (30-50k each), which are stored
as 'memo' fields in Access.

I have created the table structure in Postgres, and used the 'text' data
type for these fields.

However, when I try to INSERT the data from the Access table into the
Postgres one (I have linked the PG table into Access using ODBC), I have
big problems adding rows with the big text fields.

I should mention that adding small records (a few K each) is no problem.


The error I get from Access:

> ODBC--insert on linked table 'products' failed.
> Error while executing the query; Query string is too long (#1)


----------------------------------------------------------
Excerpts from the psqlodbc log file:

conn=81133688, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1
DSN info: DSN='PostgreSQL',server='cheetah',port='5432',dbase='companies',
user='company',passwd='xxxxx'
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',
showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0005', fetch=100, socket=4096,
unknown_sizes=0,
max_varchar_size=254, max_longvarchar_size=65536
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''

[....]

[lots of INSERTs that went OK]

[last, large INSERT (but <64k)]

----------------QResult Info
CONN ERROR: func=SC_execute, desc='', errnum=103, errmsg='Query string is
too long'
            ------------------------------------------------------------
            henv=82186080, conn=81133688, status=1, num_stmts=16
            sock=82186096, stmts=82186136, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=53, reverse=0, errornumber=0, errormsg='(null)'
            buffer_in=81140016, buffer_out=81144116
            buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=81133688, SQLDisconnect

------------------------------------------------------------------
------------------------------------------------------------------
My system info: Postgres server on Linux 2.0.

ODBC driver version: 6_40_0005 (Insight)
Postgresql database version: 6.4.2

-----------------------------------------

I have tried playing a lot with the max_longvarchar_size setting in the
ODBC control panel. I even tried to set it to (-4) which should give
unlimited size according to the FAQ. But, no dice.

Any ideas as to why I can't INSERT these big text blocks?

Thanks,

Gavrie.

--
Gavrie Philipson
Netmor Applied Modeling Research Ltd.
Bnei Brak, Israel.