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

From Robert Treat
Subject Re: Does COPY need a manual Commit?
Date
Msg-id 1028817099.21053.2.camel@camel
Whole thread Raw
In response to Does COPY need a manual Commit?  (jfo123@hotmail.com (Axier))
List pgsql-general
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




pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: any way to check if a transaction is active?
Next
From: Tom Lane
Date:
Subject: Re: SQL Comments