Re: PQputCopyData dont signal error

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: PQputCopyData dont signal error
Дата
Msg-id BANLkTinBi3fm1+pbWR_UYUTpO=QVx_rdZw@mail.gmail.com
обсуждение исходный текст
Ответ на PQputCopyData dont signal error  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Hello


>
> The way COPY works is that PQputCopyData just sends the data to the server,
> and the server will buffer it in its internal buffer and processes it when
> it feels like it. The PQputCopyData() calls don't even need to match line
> boundaries.
>

Yes, it is current behave - then documentation is obsolete

> I think you'll need to send all the data and finish the COPY until you get
> an error. If you have a lot of data to send, you might want to slice it into
> multiple COPY statements of say 50MB each, so that you can catch errors in
> between.

:( I wold to import table in one statement

Regards

Pavel Stehule



>
> --
>  Heikki Linnakangas
>  EnterpriseDB   http://www.enterprisedb.com
>


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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: PQputCopyData dont signal error
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: PQputCopyData dont signal error