Re: pg_dump and transactions

Поиск
Список
Период
Сортировка
От Ferdinand Smit
Тема Re: pg_dump and transactions
Дата
Msg-id 200203211553.g2LFrZH09812@server9.telegraafnet.nl
обсуждение исходный текст
Ответ на Re: pg_dump and transactions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: pg_dump and transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-patches по дате отправления:

Предыдущее
От: Fernando Nasser
Дата:
Сообщение: Re: Domain Support -- another round
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: Domain Support -- another round