Re: BUG #3760: Comment on restore database - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3760: Comment on restore database
Date
Msg-id 8240.1195515531@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3760: Comment on restore database  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: BUG #3760: Comment on restore database  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-bugs
Simon Riggs <simon@2ndquadrant.com> writes:
> Reason to do this now: Perf Tips have been changed for 8.3 to recommend
> using --single-transaction when restoring pg_dumps, because of fast COPY
> enhancement. Allowing this to cause an error will prevent the whole dump
> from restoring.

If it were indeed an error condition, this argument might have some
merit.  Since it is not, I don't have a lot of sympathy for a hasty
last-minute change.

regression=# comment on database foo is 'z';
WARNING:  database "foo" does not exist
COMMENT

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Hussain Jawad-FXRM43"
Date:
Subject: Re: Start up error
Next
From: Tom Lane
Date:
Subject: Re: BUG #3760: Comment on restore database