Re: Slow tab completion w/ lots of tables

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Slow tab completion w/ lots of tables
Дата
Msg-id 50338775020000250004999B@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Slow tab completion w/ lots of tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> We'd still emit quote_ident output, which means that if you did
> 
>     select * from TE<TAB>
> 
> it would change that to
> 
>     select * from "TEST
> 
> (assuming you had say TEST1 and TEST2 so it couldn't complete
> further).
> if the word-so-far has a leading quote and no embedded quotes, we
> can clearly strip the leading quote and compare the rest directly
> to the name column.  So that can be fast.  The only cases that
> need be slow are names with embedded quotes, which surely isn't a
> case that too many people care about.
> 
> In short, I think we might be able to make this fast, and more
> usable, just with hacking on psql's query generation rules. 
> There's no need for server-side changes.
I like it.  A lot.  With our camel-case naming convention, it would
make life a lot easier.
-Kevin



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow tab completion w/ lots of tables
Следующее
От: Robert Haas
Дата:
Сообщение: Re: 9.2RC1 wraps this Thursday ...