]> granicus.if.org Git - postgresql/commit
Improve tab-completion of DROP and ALTER ENABLE/DISABLE on triggers and rules.
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Mon, 23 Jun 2014 20:47:39 +0000 (23:47 +0300)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Mon, 23 Jun 2014 20:56:20 +0000 (23:56 +0300)
commit631e7f6b4e0629077408d3f8caf282627765f3f0
treedfe52d9d3e00246159d2c0d4dc4e5487e65b6456
parentf8ad8bd47306d4c34ab8f7cc6f38225b12f18a3c
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.
src/bin/psql/tab-complete.c