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

Tom Lane <tgl@sss.pgh.pa.us>

Commit: dfe67c0e85a5a613f802f78641ccc1c48845076e
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2022-01-03T23:14:01Z
Releases: 15.0
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

Files

PathChange+/−
src/bin/psql/tab-complete.c modified +17 −6

Discussion