Re: [GENERAL] Query buffer problem.

On Tue, 3 Aug 1999, Dan Wilson wrote:

> Semicolon (;) at the end of each line should fix it.

ive seen the same thing happen with COPY dumps.  seems like pg_dump doesnt
properly quote strings...

ill see if i can fix that up once i get some spare time, hopefully this
weekend.

> > Hi,
> >
> > I insert 10,000 data into PostgreSQL database. I got the problem
> > while inserting:
> >
> > query buffer max length of 20000 exceeded
> > query line ignored
> > .
> > query buffer max length of 20000 exceeded
> > query line ignored
> >
> >
> > ');
> > PQsendQuery() -- query is too long.  Maximum length is 8191
> > query buffer max length of 20000 exceeded
> > query line ignored
> > Segmentation fault (core dumped)
> >
> >
> > Would anyone know how to solve this problem, thanks in advance.
> >
> > -Albert
> >
> >
> > ______________________________________________________
> > Get Your Private, Free Email at http://www.hotmail.com
> >
>
>

---
Howie <caffeine@toodarkpark.org>   URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."