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