Re: pg_restore --format= option(without any value) should report an error as pg_dump is reporting an error

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Mahendra Singh Thalor <mahi6run(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_restore --format= option(without any value) should report an error as pg_dump is reporting an error
Date: 2026-03-15 16:31:19
Message-ID: 1d66a1e5-ce44-448b-8407-31d5ed9bc10d@dunslane.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 2026-03-15 Su 12:18 AM, Mahendra Singh Thalor wrote:
> On Sun, 13 Apr 2025 at 18:32, Mahendra Singh Thalor<mahi6run(at)gmail(dot)com> wrote:
>> Hi,
>> With "pg_restore --format=", we are not giving any error because in code, we are checking length of arg but pg_dump is reporting an error for the same option.
>>
>> For the consistency purpose, pg_dump and pg_restore both should report an error for the test case below.
>>
>> Ex: (output after this patch)but before this patch, below command is passing.
>> /pg_restore x1 -d postgres -j 10 -C --verbose --format=
>> pg_restore: error: unrecognized archive format ""; please specify "c", "d", or "t"
>>
>> Here, I am attaching a patch which is fixing the same. I added 2 TAP tests also for invalid options.
>>
>> Note: We have 2 more options in pg_restore code which validate the option if arg has non zero length. I will prepare patches for both(--host and --port). We need to add some validate function also for both these options.
>>
>> --
>> Thanks and Regards
>> Mahendra Singh Thalor
>> EnterpriseDB:http://www.enterprisedb.com
> Hi all,
> Here I am attaching a re-based patch.
>
> I think we should sync behaviour with pg_dump and pg_restore. Please
> review this patch and let me know feedback.

Let's try to deal with all these in one hit, instead if piecemeal.

cheers

andrew

--
Andrew Dunstan
EDB:https://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mahendra Singh Thalor 2026-03-15 17:02:11 Re: pg_restore --format= option(without any value) should report an error as pg_dump is reporting an error
Previous Message Tom Lane 2026-03-15 16:20:41 Re: bug: pg_dumpall with --data-only and --clean options is giving an error after some dump