Re: [GENERAL] Query buffer problem. - Mailing list pgsql-general

From Dan Wilson
Subject Re: [GENERAL] Query buffer problem.
Date
Msg-id 007a01bede34$38de21e0$261afea9@dwilson
Whole thread Raw
In response to Query buffer problem.  ("Albert Chen" <chen6178@hotmail.com>)
Responses Re: [GENERAL] Query buffer problem.
List pgsql-general
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
>


pgsql-general by date:

Previous
From: "Albert Chen"
Date:
Subject: Query buffer problem.
Next
From: Thomas Lim
Date:
Subject: Data type recommendation