Re: pg_dump and transactions

Hi Bruce,

> Can you explain the COPY troubles you have had.  Seems like a problem.

We have about 30 different postgres databases and de versions differ from 6.5
to 7.3. Maybe that causes sometimes the poblem.
An other thing is dat COPY fails when you use "strange characters". Expecialy
when you are changing from encoding. (Lots of trouble with changing from
unicode to sql-ascii)

> What about this patch which batches INSERTS into transaction blocks?
> Seems if you are worried about performance, you should be using COPY.  I
> am not inclined to apply it but rather find out why COPY isn't working
> for this person.

Wy not ?? I think that transactions in a dump are a normal thing. Beside of
that, our database-dumps must be useble even when we change from version or
database-type.

Ferdinand