I'm having difficulty with this.  Are you able to give me some instruction
on how to make the change?  I found a patch file, but the syntax doesn't
appear to work.

-----Original Message-----
From: rudi [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 28, 2002 4:48 PM
To: CF-Linux
Subject: Re: Postgres and CF


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!"


______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
------------------------------------------------------------------------------
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.

Reply via email to