Re: pg_dump restore as transaction? - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump restore as transaction?
Date
Msg-id 23350.1228153072@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump restore as transaction?  (Owen Hartnett <owen@clipboardinc.com>)
Responses Re: pg_dump restore as transaction?
List 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 by date:

Previous
From: Owen Hartnett
Date:
Subject: pg_dump restore as transaction?
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_dump restore as transaction?