Thread: BUG #5617: pg_restore behaves unexpectedly on 'invalid' command line

The following bug has been logged online:

Bug reference:      5617
Logged by:          Leo Shklovskii
Email address:      leo@thermopylae.net
PostgreSQL version: 8.4.4
Operating system:   Windows 7 (x86)
Description:        pg_restore behaves unexpectedly on 'invalid' command
line
Details:

If I put options after the filename to use for pg_restore.exe then it
behaves in a very unintuitive way. So, for example:

pg_restore.exe -U postgres d8.dump -d d8a

This should either result in the command working as expected, or an error
that the args weren't correct. I understand that arg parsing can be hard in
situations so the latter would be perfectly fine.

Instead, I get a dump of the SQL generated to the screen which is a mess and
its hard to figure out that you did something wrong.

"Leo Shklovskii" <leo@thermopylae.net> writes:
> If I put options after the filename to use for pg_restore.exe then it
> behaves in a very unintuitive way.

Hmm ... pg_dump is coded to complain about that, but pg_restore just
ignores any "extra" arguments after the filename.  I agree that's not
too good, will fix.

            regards, tom lane