Postgres Pro
Downloads
Home   >   mailing lists

RE: query buffer max length of 16384 exceeded - Mailing list pgsql-admin

From Rainer Mager
Subject RE: query buffer max length of 16384 exceeded
Date
Msg-id NEBBJBCAFMMNIHGDLFKGIEOLCCAA.rmager@vgkk.com
Whole thread Raw
In response to query buffer max length of 16384 exceeded  ("Rainer Mager" <rmager@vgkk.com>)
List pgsql-admin
Tree view 
Well, I fixed my problem. I'm sure everyone already knows this but if you
use the -d flag to pg_dump (Dump data as proper insert strings) then it
doesn't use the COPY command to insert data. Hence no HUGE strings to exceed
the buffer. Using this flag helped.


--Rainer

pgsql-admin by date:

Previous
From: "G. Anthony Reina"
Date:
Subject: Who should own pg_hba.conf?
Next
From: "Tim White"
Date:
Subject: copy command and indexes