Add tab completion of EXECUTE FUNCTION for CREATE TRIGGER in psql

Enterprise / PostgreSQL - Michael Paquier [paquier.xyz] - 26 October 2018 00:30 EDT

The change to accept EXECUTE FUNCTION as well as EXECUTE PROCEDURE in CREATE TRIGGER (added by 0a63f99) forgot to tell psql's tab completion system about this. In passing, add tab completion of EXECUTE FUNCTION/PROCEDURE after a complete WHEN ( … ) clause.

This change is version-aware, with FUNCTION being selected automatically instead of PROCEDURE depending on the backend version, PROCEDURE being an historical grammar kept for compatibility and considered as deprecated in v11.

Author: Dagfinn Ilmari Mannsåker

292ef6e277 Add tab completion of EXECUTE FUNCTION for CREATE TRIGGER in psql
src/bin/psql/tab-complete.c | 67 +++++++++++++++++++++++++++++++++++++--------
1 file changed, 56 insertions(+), 11 deletions(-)

Upstream: git.postgresql.org


  • Share