Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group