Thread: RE: query buffer max length of 16384 exceeded

I assume that you have a version prior to 7.0.  The only way to increase this would be to increate your block size, recompile, and initdb.  If you are using 7.0 or above, this is not an issue, as the limit has been removed.

Cheers...

MikeA

>>   -----Original Message-----
>>   From: Rainer Mager [mailto:rmager@vgkk.com]
>>   Sent: 12 June 2000 09:26
>>   To: pgsql-admin@postgresql.org
>>   Subject: [ADMIN] query buffer max length of 16384 exceeded
>>  
>>  
>>   Hi all,
>>  
>>      I would expect this to be a FAQ but I can't find
>>   anything in the docs or on
>>   the net. I'm trying to restore a pg_dumped database (via "psql <
>>   databasefile") and get this error:
>>  
>>      query buffer max length of 16384 exceeded
>>  
>>   Is there anyway to adjust this buffer (preferrably without
>>   rebuilding PG)?
>>   Or is there a better way to restore a database?
>>  
>>  
>>   Thanks,
>>  
>>   --Rainer
>>