Single-Transaction Utility options

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Single-Transaction Utility options
Дата
Msg-id 1134758418.2964.29.camel@localhost.localdomain
обсуждение исходный текст
Ответы Re: Single-Transaction Utility options  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Single-Transaction Utility options  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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

Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: shared description table.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Single-Transaction Utility options