That's great Dave, I'm sure it'll please many folks!!
Thanks
Andy.
Dave Page wrote:
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
!DSPAM:37,466eaba6343941575920893!
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org