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

From Alvaro Herrera
Subject Re: Single-Transaction Utility options
Date
Msg-id 20051216220506.GB28739@surnet.cl
Whole thread Raw
In response to Re: Single-Transaction Utility options  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-patches
Simon Riggs wrote:
> On Fri, 2005-12-16 at 16:04 -0300, Alvaro Herrera wrote:
> > 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?
>
> You could. That just behaves slightly differently.
>
> Maybe we should have options for both?

Are they different enough to warrant having two switches?  IIRC the
point was to have the COPY in the same transaction as the CREATE TABLE,
right?  In what way is it worse to have each table in its own
transaction?

> > Also why force it to activate the abort-on-error
> > mode?
>
> For what reason would you want it to keep running?

To restore the rest of the tables in the dump I presume ... I mean, the
behaviors are orthogonal really (_if_ you take the stance that this
should be used on a per table basis rather than a file basis, that is.
Because if you abort the transaction then clearly there's no point in
keep running, as everything will be rejected by the server anyway.)

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

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Win32 gettimeofday() comment patch
Next
From: Tom Lane
Date:
Subject: Re: Single-Transaction Utility options