Re: Does COPY need a manual Commit?

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: Does COPY need a manual Commit?
Дата
Msg-id 1028817099.21053.2.camel@camel
обсуждение исходный текст
Ответ на Does COPY need a manual Commit?  (jfo123@hotmail.com (Axier))
Список 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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: any way to check if a transaction is active?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SQL Comments