Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Added to TODO: > > * Have pg_dump use multi-statement transactions for INSERT dumps > > > For simple performance reasons, it would be good. I am not sure about > > allowing errors to continue loading. Anyone else? > > Of course, anyone who actually cares about reload speed shouldn't be > using INSERT-style dumps anyway ... I'm not sure why we should expend > effort on that rather than just telling people to use the COPY mode.
My bigger issue is that COPY will fail on a single row failure, and nothing will be in the table, while INSERT will not. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster