Re: PQputCopyData dont signal error - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: PQputCopyData dont signal error
Date
Msg-id BANLkTinBi3fm1+pbWR_UYUTpO=QVx_rdZw@mail.gmail.com
Whole thread Raw
In response to PQputCopyData dont signal error  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: PQputCopyData dont signal error
Next
From: Heikki Linnakangas
Date:
Subject: Re: PQputCopyData dont signal error