Re: Problem with the copy command need help

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: sid tow <siddy_tow(at)yahoo(dot)com>
Cc: psql mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem with the copy command need help
Date: 2005-01-28 01:42:33
Message-ID: 20050128014233.GA48464@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2005-01-28 01:52:12 Re: changing sort_mem on the fly?
Previous Message j0rd1 adame 2005-01-28 01:29:24 query variables