Re: [GENERAL] Query buffer problem.

Поиск
Список
Период
Сортировка
От Howie
Тема Re: [GENERAL] Query buffer problem.
Дата
Msg-id Pine.LNX.3.96.990804113901.19176O-100000@rabies.toodarkpark.org
обсуждение исходный текст
Ответ на Re: [GENERAL] Query buffer problem.  ("Dan Wilson" <dan_wilson@geocities.com>)
Список 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@toodarkpark.org>   URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."


В списке pgsql-general по дате отправления:

Предыдущее
От: Herouth Maoz
Дата:
Сообщение: Re: [GENERAL] Data type recommendation
Следующее
От: "Dan Wilson"
Дата:
Сообщение: Re: [GENERAL] Query buffer problem.