Query is too long

From: Silvio Emanuel Barbosa de Macedo <smacedo(at)inescn(dot)pt>
To: pgsql general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Query is too long
Date: 1999-01-15 18:41:34
Message-ID: Pine.GSO.3.96.990115182738.2460A-100000@newton.inescn.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clark Evans 1999-01-15 21:22:43 OID
Previous Message Kevin Lo 1999-01-15 18:08:54 Postgres' DBI(Pg) problems.