tab completion of enum values is broken

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема tab completion of enum values is broken
Дата
Msg-id 8ca82d89-ec3d-8b28-8291-500efaf23b25@enterprisedb.com
обсуждение исходный текст
Ответы Re: tab completion of enum values is broken  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: tab completion of enum values is broken  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
This doesn't work anymore:

create type e2 as enum ('foo', 'bar');
alter type e2 rename value 'b<TAB>

This now results in

alter type e2 rename value 'b'

Bisecting blames

commit cd69ec66c88633c09bc9a984a7f0930e09c7c96e
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date:   Thu Jan 23 11:07:12 2020 -0500

     Improve psql's tab completion for filenames.

which did deal with quoting of things to be completed, so it seems very 
plausible to be some collateral damage.

The queries issued by the completion engine are

bad

LOG:  statement: SELECT pg_catalog.quote_literal(enumlabel)   FROM 
pg_catalog.pg_enum e, pg_catalog.pg_type t  WHERE t.oid = e.enumtypid 
AND substring(pg_catalog.quote_literal(enumlabel),1,1)='b'    AND 
(pg_catalog.quote_ident(typname)='e2'         OR '"' || typname || 
'"'='e2')    AND pg_catalog.pg_type_is_visible(t.oid)    LIMIT 1000

good

LOG:  statement: SELECT pg_catalog.quote_literal(enumlabel)   FROM 
pg_catalog.pg_enum e, pg_catalog.pg_type t  WHERE t.oid = e.enumtypid 
AND substring(pg_catalog.quote_literal(enumlabel),1,2)='''b'    AND 
(pg_catalog.quote_ident(typname)='e2'         OR '"' || typname || 
'"'='e2')    AND pg_catalog.pg_type_is_visible(t.oid)    LIMIT 1000

I tried quickly fiddling with the substring() call to correct for the 
changed offset somehow, but didn't succeed.  Needs more analysis.



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

Предыдущее
От: RKN Sai Krishna
Дата:
Сообщение: Isolation levels on primary and standby
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Support tab completion for upper character inputs in psql