Michael Adler <adler@glimpser.org> writes:
> On Fri, 7 Feb 2003, Kris Jurka wrote:
>>> One of the failings of the copy protocol is that on error basically the
>>> connection is hosed. Is it possible to reset the connection state on
>>> error for the user?
> If we take libpq as the standard for what's practical to acheive with the
> FE/BE protocol, I don't think we'll be able to maintain much. libpq simply
> closes and opens the connection. (following test with a 7.2 installation)
It might be best to just leave this as an open problem until the COPY
protocol is fixed. Making COPY able to recover from errors is one of
the "must fix" items for the next FE/BE protocol revision. There had
been talk of doing this for 7.4, but given the lack of progress so far
I wouldn't want to promise results for 7.4. Maybe 7.5 though. We have
enough accumulated reasons for protocol changes that I think it's
getting to be a high-priority issue.
regards, tom lane