Search Postgresql Archives

Using the copy protocol, is there a way to be notified of a potential error before sending?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Is the copy protocol (aka PQputCopyData and PQputCopyEnd) designed to send data during many minutes,Âand is there a way to be notified of a potential error (for example an invalid value in one column) beforeÂsending PQputCopyEnd?ÂOr do I have to send my data in small chunks (for example batch of 10000 rows),Âissue a PQputCopyEnd, check for errors, and continue with the next chunk?

I tried the command "\copy ... from stdio" in psql and it looks like psql has to read the entire input before returning an error, even if the invalid value is in one of the first sent rows.

Thanks for your help and advice.

Regards,

Nicolas Grilly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux