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