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."
