BUG #17772: small glitch with autocompletion on CREATE DATABASE

W\o TO in command for sure, sorry for this

postgres=# create database atestdb owner

<TAB>

postgres=# create database atestdb owner

On Mon, 6 Feb 2023 at 02:52, PG Bug reporting form <noreply@postgresql.org>
wrote:

The following bug has been logged on the website:

Bug reference: 17772
Logged by: Andrey Lizenko
Email address: lizenko79@gmail.com
PostgreSQL version: 15.1
Operating system: Ubuntu 20.04.5 LTS
Description:

Hi, here is a very minor issue with a native psql client:

postgres=# create role atest login;
CREATE ROLE

postgres=# create role btest login;
CREATE ROLE

postgres=# create database atestdb owner to
<Pressing TAB here, nothing happens, roles list expected>

postgres=# create database atestdb owner atest;
CREATE DATABASE
<however, it works>

postgres=# reassign owned by atest to btest ;
REASSIGN OWNED
<it works also in terms of autocomplete>

postgres@xxx:~$ psql
psql (15.1 (Ubuntu 15.1-1.pgdg20.04+1))
Type "help" for help.

postgres=# show server_version;
server_version
----------------------------------
15.1 (Ubuntu 15.1-1.pgdg20.04+1)
(1 row)

--
Regards, Andrei Lizenko

Andrey Lizenko <lizenko79@gmail.com> writes:

postgres=# create database atestdb owner to
<Pressing TAB here, nothing happens, roles list expected>

AFAICS in tab-complete.c, there's no attempt to cover this case,
so this isn't a bug but an unimplemented feature. Send a patch
if it bothers you enough.

(BTW, "TO" is not part of this syntax according to the docs.)

regards, tom lane