pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #17772: small glitch with autocompletion on CREATE DATABASE
3+ messages / 3 participants
[nested] [flat]

* BUG #17772: small glitch with autocompletion on CREATE DATABASE
@ 2023-02-06 01:51 PG Bug reporting form <noreply@postgresql.org>
  2023-02-06 02:41 ` Re: BUG #17772: small glitch with autocompletion on CREATE DATABASE Andrey Lizenko <lizenko79@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: PG Bug reporting form @ 2023-02-06 01:51 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: lizenko79@gmail.com

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)



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #17772: small glitch with autocompletion on CREATE DATABASE
  2023-02-06 01:51 BUG #17772: small glitch with autocompletion on CREATE DATABASE PG Bug reporting form <noreply@postgresql.org>
@ 2023-02-06 02:41 ` Andrey Lizenko <lizenko79@gmail.com>
  2023-02-06 03:04   ` Re: BUG #17772: small glitch with autocompletion on CREATE DATABASE Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Andrey Lizenko @ 2023-02-06 02:41 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #17772: small glitch with autocompletion on CREATE DATABASE
  2023-02-06 01:51 BUG #17772: small glitch with autocompletion on CREATE DATABASE PG Bug reporting form <noreply@postgresql.org>
  2023-02-06 02:41 ` Re: BUG #17772: small glitch with autocompletion on CREATE DATABASE Andrey Lizenko <lizenko79@gmail.com>
@ 2023-02-06 03:04   ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2023-02-06 03:04 UTC (permalink / raw)
  To: Andrey Lizenko <lizenko79@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org

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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2023-02-06 03:04 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-02-06 01:51 BUG #17772: small glitch with autocompletion on CREATE DATABASE PG Bug reporting form <noreply@postgresql.org>
2023-02-06 02:41 ` Andrey Lizenko <lizenko79@gmail.com>
2023-02-06 03:04   ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox