QueryBuffer 20K exceeded - still...

From: Silvio Emanuel Barbosa de Macedo <smacedo(at)inescn(dot)pt>
To: pgsql general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: QueryBuffer 20K exceeded - still...
Date: 1999-01-19 01:25:24
Message-ID: Pine.GSO.3.96.990119011439.2395B-100000@newton.inescn.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi!
I'm still dealing with "QueryBuffer exceeded, core dump..".

I've tried using
psql -e < xx.sql
psql -f xx.sql

as Bob Dusek suggested...

or inside psql with \i xx.sql.

I've broken the sql script in two... after a few lines of the second part,
the same error... should I download again and recompile , or others have
the same problem ?

I've scanned the mailing lists, and this problem seems to have happened
before - although no clear solution !

What should I do ?

System Configuration
--------------------
Operating System : linux 2.0.36 (elf) Redhat 5.0+5.2 recompiled kernel

PostgreSQL version : 6.4.1(corrected;=6.4.2)<-maybe the problem is here?

Compiler used : gcc 2.7.2.3

Hardware:
---------
P133;64RAM;3G
Linux pluto 2.0.36 #1 Tue Oct 13 22:17:11 EDT 1998 i586 unknown

rpm -q glibc:
glibc-2.0.7-29

Versions of other tools:
------------------------
GNU Make version 3.76.1
flex version 2.5.4

After many inserts... I've got this message:

query buffer max length of 20000 exceeded
query line ignored

and then, a few inserts later, because the scritp went on...
PQsendQuery() -- query is too long. Maximum length is 8191
query buffer max length of 20000 exceeded
query line ignored
Segmentation fault (core dumped)

Thank you in advance!

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
`````````````````````````````````````````````
Silvio Emanuel Nunes Barbosa de Macedo
mailto:smacedo(at)inescn(dot)pt

INESC - Porto - Grupo CAV
Pc da Republica, 93 R/C Tel:351 2 209 42 21
4000 PORTO PORTUGAL Fax:351 2 208 41 72

Browse pgsql-general by date

  From Date Subject
Next Message Robert Chalmers 1999-01-19 01:44:05 Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL
Previous Message Valerio Santinelli 1999-01-18 23:35:56 Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL