Re: [PATCH] support tab-completion for single quote input with equal sign

On Thursday, July 22, 2021 1:05 PM, tanghy(dot)fnst(at)fujitsu(dot)com
<tanghy(dot)fnst(at)fujitsu(dot)com> wrote
> I found a problem when using tab-completion as follows:
>
> CREATE SUBSCRIPTION my_subscription
> CONNECTION 'host=localhost port=5432 dbname=postgres' [TAB]
>
> The word 'PUBLICATION' couldn't be auto completed as expected.

I too wondered about this behavior.

> v3-0001-support-tab-completion-for-CONNECTION-string-with.patch

I applied the patch and succeeded in the above case, but failed in the
below case.

=# CREATE SUBSCRIPTION s1 CONNECTION 'a=' PUBLICATION p1 <tab>

Before applying the patch, 'WITH (' was completed, but now it completes
nothing since it matches the below condition:

> 18 + else if ((HeadMatches("CREATE", "SUBSCRIPTION", MatchAny,
> "CONNECTION", MatchAny)))
> 19 + {

I updated the patch going along with the v3 direction.

What do you think?

--
Regards,

--
Atsushi Torikoshi
NTT DATA CORPORATION