I'm working with pg7.2 (I was working with 7.1, but I upgraded it in the last few days). So, I changed Drivers/PostreSQL/psqlodbc.h and upped the limit on text field size from 8190 (or whatever it was) to 16380. I didn't touch the MAX_MESSAGE_LEN. Should I be?
Evan > -----Original Message----- > From: Rudi [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 02, 2002 7:35 AM > To: CF-Linux > Subject: RE: Take 2: CF5/Postgres - "Query string is too long" > > > At 12.47 Tuesday 02/07/02 +0200, you wrote: > >On the other side, that is not related with the "query string too long > >error". That seems top be limited to 65K > > I'm talking about this (Drivers/Postgre7.1/psqlodbc.h) > > #define MAX_MESSAGE_LEN 65536 > /* This puts a limit on query size but I > don't > see an easy way round this - DJP 24-1-2001 */ > > Are you working with pg7.1 aren't you? The older versions (and > the drivers > too) had more limits. The statement length was limited to 8K, so even > changing the text-field size to 16k didn't change anything > (select worked, > insert or update didn't because MAX_MESSAGE_LEN was bound to 8k). > > > > -- > Rd > > "Soft as the massacre of Suns > By Evening's Sabres slain" > [E.Dickinson] > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ 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.
