Type Ahead Issue

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: "PostgreSQL (SQL)" <pgsql-sql(at)postgresql(dot)org>
Subject: Type Ahead Issue
Date: 2012-03-07 18:42:16
Message-ID: CAAQLLO4=zdqtxGMbPWKyWHoi-=t+CY1sf_72gzkU80Rq-Pr1xg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I don't know if this is an issue with my client (Psql) or if it's
something I'm doing wrong but I've noticed this issue before and can't
figure it out. When I'm using the psql client, I really rely on the
tab / type ahead auto completion. When I run my command on one single
line, it works fine but when I break my line up into segments, it
doesn't understand what I'm trying to do:

ALTER TABLE meh ALTER C (if you press 'tab' after the 'c', psql knows
the only logical option is 'COLUMN'.

When I do the following, I don't get the same results:

ALTER TABLE meh
ALTER C (when I press 'tab' after 'C' to auto complete 'COLUMN', I get
the options only for 'COLLATION' or 'CONVERSION'. Why does it do this?
Am I missing something here? When the command is on one line, auto
complete works fine but when I break it up as show above in the 2nd
example, it acts like 'COLUMN' isn't even a valid option but if I
manually type the word 'COLUMN' and finish the command, it works. Why
is this acting this way?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2012-03-07 20:37:55 Re: Type Ahead Issue
Previous Message Adam Cornett 2012-03-07 18:28:28 Re-Sync Stand By Server