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