Uppercase tab completion keywords in psql?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Uppercase tab completion keywords in psql?
Date: 2012-03-22 21:49:55
Message-ID: 20120322214955.GA4754@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Postgres 9.2 has been modified so psql no longer uppercases SQL keywords
when using tab completation, by this commit:

commit 69f4f1c3576abc535871c6cfa95539e32a36120f
Author: Peter Eisentraut <peter_e(at)gmx(dot)net>
Date: Wed Feb 1 20:16:40 2012 +0200

psql: Case preserving completion of SQL key words

Instead of always completing SQL key words in upper case, look at
the word being completed and match the case.

reviewed by Fujii Masao

For example, in 9.1:

test=> sel<TAB>

becomes

test=> SELECT

However, in 9.2, this will produce:

test=> select

FYI, fortunately this will still complete as upper case:

test=> Sel<TAB>

Robert Haas and I are disappointed by this change. I liked the fact
that I could post nice-looking SQL queries without having to use my
capslock key (which I use as a second control key). Any chance of
reverting this change?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2012-03-22 21:56:00 Re: Uppercase tab completion keywords in psql?
Previous Message Dimitri Fontaine 2012-03-22 21:44:24 Re: Finer Extension dependencies