Improve tab-completion of DROP and ALTER ENABLE/DISABLE on triggers and rules.

Heikki Linnakangas <heikki.linnakangas@iki.fi>

Commit: 631e7f6b4e0629077408d3f8caf282627765f3f0
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: 2014-06-23T20:56:20Z
Releases: 9.5.0
Improve tab-completion of DROP and ALTER ENABLE/DISABLE on triggers and rules.

At "DROP RULE/TRIGGER triggername ON ...", tab-complete tables that have
a rule/trigger with that name.

At "ALTER TABLE tablename ENABLE/DISABLE TRIGGER/RULE ...", tab-complete to
rules/triggers on that table. Previously, we would tab-complete to all
rules or triggers, not just those that are on that table.

Also, filter out internal RI triggers from the list. You can't DROP them,
and enabling/disabling them is such a rare (and dangerous) operation that
it seems better to hide them.

Andreas Karlsson, reviewed by Ian Barwick.

Files

PathChange+/−
src/bin/psql/tab-complete.c modified +113 −1