Greg Smith wrote:
Absolutely, that's the whole point of logging to a file in the first
place. What needs to happen here is that when one is aborted, you
need to make sure that fact is logged, and with enough information
(the pid?) to tie it to the COPY that failed. Then someone can crawl
the logs to figure out what happened and what data did and didn't get
loaded. Ideally you'd want to have that as database table information
instead, to allow automated recovery and re-commit in the cases where
the error wasn't inherent in the data but instead some other type of
database failure.
If one is aborted, nothing gets loaded anyway. Now if you want a
separate log of the successful commands, I don't think that should apply
just to COPY but to any operation (insert, update, DDL, ...) if you want
to build some automatic retry mechanism. But this seems independent from
COPY to me.
manu
--
Emmanuel Cecchet
Aster Data Systems
Web: http://www.asterdata.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
