Kris Jurka <[EMAIL PROTECTED]> writes:
> This patch makes pg_dump wrap insert dumps (-d, -D) in a transaction to
> speed the restore process.
What's the point of this, compared to Simon's recent patch adding an
option to wrap the whole output in one big transaction? An intermediate
level doesn't
This patch makes pg_dump wrap insert dumps (-d, -D) in a transaction to
speed the restore process. It also adds an option to disable these
transactions for doing things like copying only newly inserted values from
one database to another (assuming old ones will fail on an unique
constraint).
On Wed, Apr 12, 2006 at 10:00:29AM -0400, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > It's not clear why the code was added in the first place,
>
> I thought it was there to support client-side authentication (ie,
> verifying the server's certificate). We don't support that right
> now
Martijn van Oosterhout writes:
> It's not clear why the code was added in the first place,
I thought it was there to support client-side authentication (ie,
verifying the server's certificate). We don't support that right
now but we ought to.
regards, tom lane
-