Single-Transaction Utility options - Mailing list pgsql-patches

From Simon Riggs
Subject Single-Transaction Utility options
Date
Msg-id 1134758418.2964.29.camel@localhost.localdomain
Whole thread Raw
Responses Re: Single-Transaction Utility options  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Single-Transaction Utility options  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-patches
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.

In pgrestore the -N option also forces the -e option: exit on error.

Passes make check on cvstip, plus some other basic testing.
No docs as yet.

Patches are completely independent of each other, the only connection
between them is at the conceptual level.

[Why have I done this? This is a precursor to the introduction of
WAL-bypass for COPY, when run in the same transaction in which a table
was created. Together, they will allow faster upgrades and restores.]

Best Regards, Simon Riggs

Attachment

pgsql-patches by date:

Previous
From: Kris Jurka
Date:
Subject: shared description table.
Next
From: Tom Lane
Date:
Subject: Re: Single-Transaction Utility options