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
Description: text/x-patch (5.4 KB)
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2005-12-16 18:59:03|
|Subject: Re: Single-Transaction Utility options |
|Previous:||From: Simon Riggs||Date: 2005-12-16 13:17:25|
|Subject: Re: How much expensive are row level statistics?|