Re: pg_dump restore as transaction?

From: Owen Hartnett <owen(at)clipboardinc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump restore as transaction?
Date: 2008-12-01 17:46:18
Message-ID: p0624080fc559d3508b06@[192.168.0.107]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 12:37 PM -0500 12/1/08, Tom Lane wrote:
>Owen Hartnett <owen(at)clipboardinc(dot)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

Thanks to everybody for their help. You guys are great.

-Owen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sebastian Tennant 2008-12-01 17:48:35 Re: Detecting changes to certain fields in 'before update' trigger functions
Previous Message Alvaro Herrera 2008-12-01 17:40:02 Re: pg_dump restore as transaction?