Re: problem with PQsendQuery/PQgetResult and COPY FROM statement

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: problem with PQsendQuery/PQgetResult and COPY FROM statement
Дата
Msg-id 20060522065430.GA24404@svana.org
обсуждение исходный текст
Ответ на problem with PQsendQuery/PQgetResult and COPY FROM statement  (max.poletto@gmail.com)
Список pgsql-hackers
On Fri, May 19, 2006 at 11:51:00AM -0700, max.poletto@gmail.com wrote:
> I attempt to execute a "COPY test FROM STDIN" using PQsendQuery.
> Subsequently, after the appropriate poll()/PQconsumeInput/PQisBusy
> calls, PQgetResult returns tens of millions of (invalid?) non-null
> PGresults.  This behavior seems incorrect, and sometimes causes my
> application to exhaust memory and crash.

In addition to the issues other people have pointed out, when using
COPY you transfer the data with PQputCopyData()/PQgetCopyData().

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: String Similarity
Следующее
От: "Victor B. Wagner"
Дата:
Сообщение: Re: SSL certificate info on SQL level and HSM support for libpq