Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore --single-transaction and --clean - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pg_restore --single-transaction and --clean
Date
Msg-id 603c8f071002100817u7a624b86p289f02e9d0389bf4@mail.gmail.com
Whole thread Raw
In response to Re: pg_restore --single-transaction and --clean  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_restore --single-transaction and --clean
List pgsql-hackers
Tree view 
On Wed, Feb 10, 2010 at 10:16 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp> writes:
>> Is it a TODO item to replace "DROP" into "DROP IF EXISTS"
>> for cleanup commands in pg_restore?
>
> No.  We try to avoid using nonstandard SQL in dumps.

How often do we succeed?  It seems unlikely that our dumps would be
restorable into any other database.

...Robert

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Some belated patch review for "Buffers" explain analyze patch
Next
From: "Kevin Grittner"
Date:
Subject: Re: pg_restore --single-transaction and --clean