Re: Single-Transaction Utility options - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: Single-Transaction Utility options
Date
Msg-id 20051216190458.GB26971@surnet.cl
Whole thread Raw
In response to Single-Transaction Utility options  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Single-Transaction Utility options
List pgsql-patches
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.

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Single-Transaction Utility options
Next
From: Jaime Casanova
Date:
Subject: Re: Single-Transaction Utility options