CREATE SUBSCRIPTION -- add missing tab-completes

Peter Smith <smithpb2250@gmail.com>

From: Peter Smith <smithpb2250@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-04-05T00:27:33Z
Lists: pgsql-hackers

Attachments

There are some recent comment that added new options for CREATE SUBSCRIPTION

"Add new predefined role pg_create_subscription." [1]
This added a new "password_required" option.

"Add a run_as_owner option to subscriptions." [2]
This added a "run_as_owner" option.

~~

AFAICT the associated tab-complete code was accidentally omitted.

PSA patches to add those tab completions.

------
[1] https://github.com/postgres/postgres/commit/c3afe8cf5a1e465bd71e48e4bc717f5bfdc7a7d6
[2] https://github.com/postgres/postgres/commit/482675987bcdffb390ae735cfd5f34b485ae97c6

Kind Regards,
Peter Smith.
Fujitsu Australia

Commits

  1. Doc: Fix the datatype of the newly added SUBSCRIPTION options.

  2. Add tab-completion for newly added SUBSCRIPTION options.

  3. Add a run_as_owner option to subscriptions.

  4. Add new predefined role pg_create_subscription.