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

Started by Leo Shklovskiiover 15 years ago2 messagesbugs
Jump to latest
#1Leo Shklovskii
leo@thermopylae.net

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Leo Shklovskii (#1)
Re: BUG #5617: pg_restore behaves unexpectedly on 'invalid' command line

"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