Re: Single-Transaction Utility options

Simon Riggs wrote:
> The following patches add a -N option to psql and pgrestore.
>
> This option adds a BEGIN at the start and a COMMIT at the end of all
> commands, causing all statements to be executed as a single transaction.

Why use it around the whole file and not only around that particular
table's operations?  Also why force it to activate the abort-on-error
mode?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.