Thread: Does COPY need a manual Commit?

Does COPY need a manual Commit?

From
jfo123@hotmail.com (Axier)
Date:
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

Re: Does COPY need a manual Commit?

From
Robert Treat
Date:
Shouldn't be necessary, though not a bad idea if you make the output
visible so you can tell exactly where you crashed.

Robert Treat

On Wed, 2002-08-07 at 02:40, Axier wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html