Postgres Pro
Downloads
Home   >   mailing lists

Does COPY need a manual Commit? - Mailing list pgsql-general

From jfo123@hotmail.com (Axier)
Subject Does COPY need a manual Commit?
Date
Msg-id ae3e57f6.0208062240.6185f906@posting.google.com
Whole thread Raw
Responses Re: Does COPY need a manual Commit?  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: jfo123@hotmail.com (Axier)
Date:
Subject: Re: PostgreSQL + PHP 4.2x buggy with Apache?
Next
From: The Doctor What
Date:
Subject: Re: inet <<= and indexes