From: | Howie <caffeine(at)toodarkpark(dot)org> |
---|---|
To: | Dan Wilson <dan_wilson(at)geocities(dot)com> |
Cc: | Albert Chen <chen6178(at)hotmail(dot)com>, pgsql general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Query buffer problem. |
Date: | 1999-08-04 11:39:58 |
Message-ID: | Pine.LNX.3.96.990804113901.19176O-100000@rabies.toodarkpark.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)toodarkpark(dot)org> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Wilson | 1999-08-04 13:56:11 | Re: [GENERAL] Query buffer problem. |
Previous Message | Howie | 1999-08-04 11:08:30 | Re: [SQL] referential integrity |