Does COPY need a manual Commit?

From: jfo123(at)hotmail(dot)com (Axier)
To: pgsql-general(at)postgresql(dot)org
Subject: Does COPY need a manual Commit?
Date: 2002-08-07 06:40:29
Message-ID: ae3e57f6.0208062240.6185f906@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am using COPY FROM for volume inserts and every $commitafter I make
a end_copy and restarts the process. Is this necessary for not losing
data
in case of a crasch or is it a good way to use more code and CPU than
actually needed?

regards, Axier

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2002-08-07 06:45:11 Re: Importing blob
Previous Message Alexander Pucher 2002-08-07 06:36:20 Re: MySQL or Postgres ?