Re: [GENERAL] Query is too long

Hey there,

One way to execute .sql scripts in your database is this:

psql -e dbname < script.sql

That is how we recreate our databases from a dump file.

"psql -ef script.sql dbname" seems to have the same problem
you were having with the \i command:

query buffer max length of 20000 exceeded

good luck,

Bob


On Fri, 15 Jan 1999, Silvio Emanuel Barbosa de Macedo wrote:

>
> 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
>
>
>
>
>
>
>
>
>