Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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









pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group