Postgres Pro
Downloads
Home   >   mailing lists

Using the copy protocol, is there a way to be notified of a potential error before sending? - Mailing list pgsql-general

From Nicolas Grilly
Subject Using the copy protocol, is there a way to be notified of a potential error before sending?
Date
Msg-id AANLkTik5RaZ+CCBG28Q=giJLckvjPrTq5syA9TryUKSV@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Dario Beraldi
Date:
Subject: Cluster table and order information
Next
From: Herouth Maoz
Date:
Subject: Book recommendation?