Tab completion: don't offer valid constraints in VALIDATE CONSTRAINT.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 3 Jan 2022 23:14:01 +0000 (18:14 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 3 Jan 2022 23:14:01 +0000 (18:14 -0500)
commitdfe67c0e85a5a613f802f78641ccc1c48845076e
tree5965c39302437ec6662026b0c33a160f4228a446
parent8a2e323f208557acbfdc911516e84ec017f5a6ca
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
src/bin/psql/tab-complete.c