pgsql: psql tab completion improvements, from Greg Sabino Mullane: * - Mailing list pgsql-committers

From neilc@svr1.postgresql.org (Neil Conway)
Subject pgsql: psql tab completion improvements, from Greg Sabino Mullane: *
Date
Msg-id 20050518044740.69A25528C2@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
psql tab completion improvements, from Greg Sabino Mullane:

* Made DELETE into "DELETE FROM"
* Moved ANALZYE to the end of the list to ease EXPLAIN / VACUUM
  conflicts
* Removed the ANALYZE xx semicolon completion: we don't do that anywhere
  else
* Add DECLARE support
* Add parens for DROP AGGREGATE
* Add "CASCADE | RESTRICT" for DROP xx
* Make EXPLAIN <tab> a lot smarter
* GROUP "BY" and ORDER "BY"
* "ISOLATION" becomes "ISOLATION LEVEL"
* Fix error in which REVOKE xx ON yy was receiving "TO", now gets "FROM"
* Add GRANT/REVOKE xx ON yy TO/FROM choices: usernames, GROUP, PUBLIC
* PREPARE xx <tab> AS "SELECT | INSERT | UPDATE | DELETE"
* Add = at end of UPDATE xx SET yy
* Beef up VACUUM stuff

Modified Files:
--------------
    pgsql/src/bin/psql:
        tab-complete.c (r1.127 -> r1.128)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/tab-complete.c.diff?r1=1.127&r2=1.128)

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Extend the pg_locks system view so that it can fully display all
Next
From: neilc@svr1.postgresql.org (Neil Conway)
Date:
Subject: pgsql: Upon closer inspection, Greg's psql tab completion patch leaks