pgsql: Add tab completion of EXECUTE FUNCTION for CREATE TRIGGER in psq

Started by Michael Paquierover 7 years ago1 messagescomitters

michael@paquier.xyz

over 7 years ago

Add tab completion of EXECUTE FUNCTION for CREATE TRIGGER in psql

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.

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
Reviewed-by: Tom Lane, Michael Paquier
Discussion: /messages/by-id/d8jmur4q4yc.fsf@dalvik.ping.uio.no

Branch
------
REL_11_STABLE

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

Modified Files
--------------
src/bin/psql/tab-complete.c | 66 ++++++++++++++++++++++++++++++++++++++-------
1 file changed, 56 insertions(+), 10 deletions(-)