You could recompile with a larger blocksize. The query string length is linked to this, so with a block size of 8k, you get a query string length of 16k. I think that the max block size is 32k, which will give you a query string length of 64k. This is not a complete solution though, and in 7.0 the query string length is limited only by your memory available (although certain of the client interfaces may still link it to the block size).
MikeA
>> -----Original Message-----
>> From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
>> Sent: 29 March 2000 09:09
>> To: Walter M. Yuan
>> Cc: [EMAIL PROTECTED]
>> Subject: Re: [ADMIN] query length
>>
>>
>>
>>
>> > ----------
>> > From: Peter Eisentraut[SMTP:[EMAIL PROTECTED]]
>> > Sent: Wednesday, March 29, 2000 10:08:56 AM
>> > To: Walter M. Yuan
>> > Cc: [EMAIL PROTECTED]
>> > Subject: Re: [ADMIN] query length
>> > Auto forwarded by a Rule
>> >
>> On Tue, 28 Mar 2000, Walter M. Yuan wrote:
>>
>> > >PQsendQuery() -- query is too long. Maximum length is 16382
>> > >query buffer max length of 16384 exceeded
>> >
>> > Can anyone give me some quick advice on how to change
>> this setting?
>>
>> Upgrade to 7.0. There isn't a way to change it.
>>
>> --
>> Peter Eisentraut Sernanders v�g 10:115
>> [EMAIL PROTECTED] 75262 Uppsala
>> http://yi.org/peter-e/ Sweden
>>
