Thread: Query buffer problem.

Query buffer problem.

From
"Albert Chen"
Date:
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

Re: [GENERAL] Query buffer problem.

From
"Dan Wilson"
Date:
Semicolon (;) at the end of each line should fix it.

-Dan


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


Re: [GENERAL] Query buffer problem.

From
Howie
Date:
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."


Re: [GENERAL] Query buffer problem.

From
"Dan Wilson"
Date:
While you're at it, can you fix pg_dump to also dump the primary key
information to maintain that information.

Currently it dumps the Primary Keys as UNIQUE indices, which is OK, but if
you want to maintain that information across different dbms's you need the
primary key integrity.

-Dan

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


List moderator please take me off from this list

From
ralli@poboxes.com
Date:
Hi,

Can some one guide me how can I unsubscribe from this list .

ralli@poboxes.com