Thread: problem with buffer in psql

problem with buffer in psql

From
"Hector Morales"
Date:
I need insert aproximatly 20,000 tuples in one table and i run

psql dbname -f scriptofquerys

so show the next error

query buffer maxlength of 16,384 exceeded

thank for your help

Hector Morales





Re: problem with buffer in psql

From
"Len Morgan"
Date:
Did your "scriptofquerys" have a semicolon at the end of EACH query?  If
not, the parser will keep collecting lines until it hits the query length
limit.

len morgan


-----Original Message-----
From: Hector Morales <hearmocr@yahoo.com>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Monday, May 28, 2001 9:00 AM
Subject: [GENERAL] problem with buffer in psql


>I need insert aproximatly 20,000 tuples in one table and i run
>
>psql dbname -f scriptofquerys
>
>so show the next error
>
>query buffer maxlength of 16,384 exceeded
>
>thank for your help
>
>Hector Morales
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>


Re: problem with buffer in psql

From
Tom Lane
Date:
"Hector Morales" <hearmocr@yahoo.com> writes:
> query buffer maxlength of 16,384 exceeded

Use a more recent Postgres release.

            regards, tom lane