Re: pg_dump and transactions

From: Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: pg_dump and transactions
Date: 2002-03-21 15:53:30
Message-ID: 200203211553.g2LFrZH09812@server9.telegraafnet.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Thomas Lockhart 2002-03-21 16:10:08 Re: Domain Support -- another round
Previous Message Rod Taylor 2002-03-21 15:42:18 Re: [PATCHES] Domain Support -- another round