Re: pgsql: Add psql option: -1 or --single-transaction - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Add psql option: -1 or --single-transaction
Date
Msg-id 13782.1139929022@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Add psql option: -1 or --single-transaction  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: pgsql: Add psql option: -1 or --single-transaction  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-committers
Simon Riggs <simon@2ndquadrant.com> writes:
> How should it work?

> 1. Remove the BEGIN and COMMIT around blobs?
> 2. Use SAVEPOINT ?

> Presumably (1).

Yeah, there is no need for the per-blob begin/commit if we've got one
around the whole restore.

One thing to be careful of is not to suppress BEGINs that are sent on
the dumping side --- it's sometimes hard to tell which parts of pg_dump
execute when.

            regards, tom lane

pgsql-committers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: pgsql: Add psql option: -1 or --single-transaction
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: pgsql: Add psql option: -1 or --single-transaction