Query truncation problems

From: Paul Haddon <paullist(at)mail(dot)hartingdale(dot)com(dot)au>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Query truncation problems
Date: 2001-12-19 02:40:44
Message-ID: 20011219134044.A8675@mail.hartingdale.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I'm getting truncation errors when I try to retrieve more than
65k worth of data from a field.

I'm accessing Postgresql on Linux from Cold Fusion 4 on NT.

Version info:

Global Options:
Version='07.01.0009', fetch=100, socket=4096, unknown_sizes=0,
max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''

PostgreSQL version string = 'PostgreSQL 7.1.3 on i686-pc-linux-gnu,
compiled by GCC egcs-2.91.66'

I can insert a record ok, and confirm that it's correct by looking
at it with psql on the Linux host, but when I try to retrieve it
it's missing everything after the 65000 character mark.

Looking at the logs shows:

The 5th item was truncated
The buffer size = 65000

Do I have one of the settings incorrect, or is it a problem with
the driver?

Thanks

Paul Haddon
Technical Services Manager
Hartingdale Internet

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2001-12-19 04:21:29 Re: Query truncation problems
Previous Message Mike Miller 2001-12-17 21:01:08 FW: Trouble with LargeObjects and ODBC, backend crash?