Andy Shellam wrote:
> Yep I agree, with pg_restore, warnings also generate a non-zero return
> code, but the restore does complete successfully, so this is mis-leading.
> An example is "language <xxx> already exists" - pg_restore just throws a
> warning to let you know this, but the restore is successful.
>
> Perhaps what might work better is a message box - if you've already
> performed a restore but it returned non-zero, and OK is pressed again in
> the same dialogue box, throw up a message saying something like "you've
> already attempted a restore, are you sure you want to run it again?"
Now thats a solution I'm happy with - I've added code to do this, if a
restore (or backup) is attempted from the same dialog invocation, with
the same filename as previously used.
Thanks, Dave