Re: IF (NOT) EXISTS in psql-completion

On 29.03.2016 10:59, Pavel Stehule wrote:
> Hi
>
> 2016-03-29 8:43 GMT+02:00 Kyotaro HORIGUCHI
> <horiguchi.kyotaro@lab.ntt.co.jp <mailto:horiguchi.kyotaro@lab.ntt.co.jp>>:
>
>     Thank you Pavel, David.
>
>     Thank you for pointing syntaxes to be addressed. Most of the are
>     addressed in the attached patch.
>
>
>     At Tue, 22 Mar 2016 12:57:27 -0400, David Steele
>     <david@pgmasters.net <mailto:david@pgmasters.net>> wrote in
>     <56F17977.8040503@pgmasters.net <mailto:56F17977.8040503@pgmasters.net>>
>     > Hi Kyotaro,
>     >
>     > On 3/18/16 3:22 AM, Pavel Stehule wrote:
>     >
>     > >     I am looking this patch. It looks well, but this feature doesn't
>     > >     respect upper or lower chars. It enforce upper chars. This is not
>     > >     consistent with any other autocomplete.
>
>     As mentioned before, upper-lower problem is an existing
>     issue. The case of the words in a query result list cannot be
>     edited since it may contain words that should not be changed,
>     such as relation names. So we can address it only before issueing
>     a query but I haven't found simple way to do it.
>
>
> This is unpleasant. I am sorry. I had very uncomfortable feeling from
> this behave. I am thinking so it should be solvable - you have to
> convert only keyword IF EXISTS or IF NOT EXISTS. Maybe there are not
> trivial solution, but this should be fixed.
>

Hello,

Can we do something like in the patch? This patch should be applied
after the patch
"0001-Suggest-IF-NOT-EXISTS-for-tab-completion-of-psql_v3.patch".

--
Artur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company