Improve the HINT message of the ALTER command for postgres_fdw

From: bt21masumurak <bt21masumurak(at)oss(dot)nttdata(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Improve the HINT message of the ALTER command for postgres_fdw
Date: 2021-10-08 07:18:02
Message-ID: 557d06cebe19081bfcc83ee2affc98d3@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

When 'ALTER FOREIGN DATA WRAPPER OPTIONS' is executed against
postgres_fdw, the HINT message is printed as shown below, even though
there are no valid options in this context.

=# ALTER FOREIGN DATA WRAPPER postgres_fdw OPTIONS (format 'csv');
ERROR: invalid option "format"
HINT: Valid options in this context are:

I made a patch for this problem.

regards,
Kosei Masumura

Attachment Content-Type Size
diff.patch text/x-diff 740 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2021-10-08 07:28:04 Re: More business with $Test::Builder::Level in the TAP tests
Previous Message osumi.takamichi@fujitsu.com 2021-10-08 07:09:36 RE: Skipping logical replication transactions on subscriber side