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
|
Список | 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 по дате отправления: