Tab completion not listing schema list for create/alter publication for all tables in schema - Mailing list pgsql-hackers

From vignesh C
Subject Tab completion not listing schema list for create/alter publication for all tables in schema
Date
Msg-id CALDaNm0hBO+tZqBWhBjTVxyET1GWANq5K9XpQ07atSxnFXbG7w@mail.gmail.com
Whole thread Raw
Responses Re: Tab completion not listing schema list for create/alter publication for all tables in schema
List pgsql-hackers
Hi,

I noticed that the following commands "CREATE PUBLICATION pub1 FOR ALL
TABLES IN SCHEMA" and  "ALTER PUBLICATION pub1 ADD ALL TABLES IN
SCHEMA" does not complete with the schema list. I feel this is because
of the following code in tab-complete.c:
.........
COMPLETE_WITH_QUERY_PLUS(Query_for_list_of_schemas
" AND nspname NOT LIKE E'pg\\\\_%'",
"CURRENT_SCHEMA");
.........
Here "pg\\\\_%" should be "pg\\\\_%%".
Attached a patch to handle this.
Thoughts?

Regards,
Vignesh

Attachment

pgsql-hackers by date:

Previous
From: Zhihong Yu
Date:
Subject: Re: BufferAlloc: don't take two simultaneous locks
Next
From: Melanie Plageman
Date:
Subject: Re: Issue with pg_stat_subscription_stats