Does COPY need a manual Commit?
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
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
Show quoted text
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?