Sun, Jul 28, 2002 at 09:34:01AM -0600 scrivesti > Has anybody had a problem with selecting text longer than 8190 in CF with > Postgres? If so, did changing TEXT_FIELD_SIZE 8190 to something like > #define TEXT_FIELD_SIZE 1024*1024 in psqlodbc.h help?
Yes, but 1Mb (1024^2) it's definately too much, unless you have special needs. Consider that you are hard-coding a 1Mb malloc constant: whatever text size you are going to select, the driver will ask for that Mega. Personally, I found that doubling that buffer will suffices, waiting for a more serious fix (a dynamic malloc. I tried it myself but after a while I got lost somewhere in the code-flow and I gave up) -- Rd "Aujourd'hui l'espace est splendide! Sans mors, sans �perons, sans bride, Partons � cheval sur le vin Pour le ciel f�erique et divin!" ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
