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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend