Query is too long - Mailing list pgsql-general

From Silvio Emanuel Barbosa de Macedo
Subject Query is too long
Date
Msg-id Pine.GSO.3.96.990115182738.2460A-100000@newton.inescn.pt
Whole thread Raw
Responses Re: [GENERAL] Query is too long
List pgsql-general
Hi!
I was using psql to insert data into the database.
I have *.sql files with the necessary scripts, eg:

insert into descritor values (4992,'MARCHAS DE LISBOA','te','cl');

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)


Gdb on the core:
(gdb) bt
#0  0x401066f8 in ?? () from /lib/libc.so.6
#1  0x401066a1 in ?? () from /lib/libc.so.6
#2  0x804e85b in MainLoop ()
#3  0x804df44 in HandleSlashCmds ()
#4  0x804e7c0 in MainLoop ()
#5  0x804ef2d in main ()

What has happened ? How can I avoid it ? Maybe using psql -f instead using
\i inside psql ?



,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
`````````````````````````````````````````````
Silvio Emanuel Nunes Barbosa de Macedo
mailto:smacedo@inescn.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:

Previous
From: Kevin Lo
Date:
Subject: Postgres' DBI(Pg) problems.
Next
From: Clark Evans
Date:
Subject: OID