problem with buffer in psql

Started by Hector Moralesalmost 25 years ago3 messagesgeneral
Jump to latest
#1Hector Morales
hearmocr@yahoo.com

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

#2Len Morgan
len-morgan@crcom.net
In reply to: Hector Morales (#1)
Re: problem with buffer in psql

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

Show quoted text

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

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Hector Morales (#1)
Re: problem with buffer in psql

"Hector Morales" <hearmocr@yahoo.com> writes:

query buffer maxlength of 16,384 exceeded

Use a more recent Postgres release.

regards, tom lane