Query is too long

Поиск
Список
Период
Сортировка
От Silvio Emanuel Barbosa de Macedo
Тема Query is too long
Дата
Msg-id Pine.GSO.3.96.990115182738.2460A-100000@newton.inescn.pt
обсуждение исходный текст
Ответы Re: [GENERAL] Query is too long  (Bob Dusek <bobd@palaver.net>)
Список 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 по дате отправления:

Предыдущее
От: Kevin Lo
Дата:
Сообщение: Postgres' DBI(Pg) problems.
Следующее
От: Clark Evans
Дата:
Сообщение: OID