Problem with the copy command need help

Started by sid towabout 21 years ago2 messagesgeneral
Jump to latest
#1sid tow
siddy_tow@yahoo.com

hi,

I am updating a database using COPY commands. If
the commmand breaks in between updating the database,
is there any way to find the log of the previous
updation or which part or row the loading broke.

Regards
Sid

__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail

#2Michael Fuhr
mike@fuhr.org
In reply to: sid tow (#1)
Re: Problem with the copy command need help

On Thu, Jan 27, 2005 at 12:53:00AM -0800, sid tow wrote:

I am updating a database using COPY commands. If
the commmand breaks in between updating the database,
is there any way to find the log of the previous
updation or which part or row the loading broke.

Are you saying the COPY command is failing? It should print an
error if it does, giving a hint at which line is causing a problem.
What error, if any, are you seeing?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/