Horton

Re: Add missing tab completion for ALTER TABLE ADD COLUMN IF NOT EXISTS

Karina Litskevich <litskevichkarina@gmail.com>

View thread View on postgr.es
From: Karina Litskevich <litskevichkarina@gmail.com>
To: Kirill Reshke <reshkekirill@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-11-08T08:14:13Z
Lists: pgsql-hackers 
I did a quick testing.

As expected, both "ALTER TYPE xxx RENAME VALUE yyy TO zzz CASCADE" and
"ALTER TYPE xxx RENAME VALUE yyy TO zzz RESTRICT" in v4-0002 cause
syntax errors.

In v4-0004 you might also want to complete
"CREATE MATERIALIZED VIEW... USING ..." with "AS".

Other completions work fine.

Best regards,
Karina Litskevich
Postgres Professional: http://postgrespro.com/

Commits

  1. psql: Tab completion for CREATE MATERIALIZED VIEW ... USING

  2. psql: Tab completion for CREATE TEMP TABLE ... USING

  3. psql: Tab completion for ALTER TYPE ... CASCADE/RESTRICT

  4. psql: Tab completion for ALTER TYPE ... ADD ATTRIBUTE

  5. Add more tab completion for CREATE TABLE in psql