Query truncation problems
От | Paul Haddon |
---|---|
Тема | Query truncation problems |
Дата | |
Msg-id | 20011219134044.A8675@mail.hartingdale.com.au обсуждение исходный текст |
Список | 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
В списке pgsql-odbc по дате отправления: