Re: pg_dump restore as transaction?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump restore as transaction?
Дата
Msg-id 23350.1228153072@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump restore as transaction?  (Owen Hartnett <owen@clipboardinc.com>)
Ответы Re: pg_dump restore as transaction?  (Owen Hartnett <owen@clipboardinc.com>)
Список pgsql-general
Owen Hartnett <owen@clipboardinc.com> writes:
> If my perusal of the sql generated by pg_dump is correct, then it
> doesn't appear that it's wrapped in a transaction, and thus might be
> able to only complete a partial restore?

That's correct, and intentional.  You can use pg_restore's -1 switch
or add begin/end manually if you don't want it to work that way.

            regards, tom lane

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

Предыдущее
От: Owen Hartnett
Дата:
Сообщение: pg_dump restore as transaction?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_dump restore as transaction?