pgsql: Tab completion: don't offer valid constraints in VALIDATE CONSTR

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Tab completion: don't offer valid constraints in VALIDATE CONSTR
Date: 2022-01-03 23:14:06
Message-ID: E1n4WWk-0004yV-Lj@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Tab completion: don't offer valid constraints in VALIDATE CONSTRAINT.

Improve psql so that "ALTER TABLE foo VALIDATE CONSTRAINT <TAB>"
only offers not-convalidated entries. While it's not formally
wrong to offer validated ones, there's not much point either,
and it can save some typing if we incorporate this knowledge.

David Fetter, reviewed by Aleksander Alekseev

Discussion: https://postgr.es/m/20210427002433.GB17834@fetter.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/dfe67c0e85a5a613f802f78641ccc1c48845076e

Modified Files
--------------
src/bin/psql/tab-complete.c | 23 +++++++++++++++++------
1 file changed, 17 insertions(+), 6 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2022-01-04 15:27:51 pgsql: pg_dump: Refactor dumpDatabase()
Previous Message Tom Lane 2022-01-03 21:12:21 pgsql: Handle mixed returnable and non-returnable columns better in IOS