Re: Does COPY need a manual Commit?

Поиск
Список
Период
Сортировка
Искать

Re: Does COPY need a manual Commit?

От:
Robert Treat <xzilla@users.sourceforge.net>
Дата:
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

Does COPY need a manual Commit?

От:
jfo123@hotmail.com (Axier)
Дата:
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
FAQ