Tab completion not listing schema list for create/alter publication for all tables in schema
vignesh C <vignesh21@gmail.com>
From: vignesh C <vignesh21@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-03-13T17:03:43Z
Lists: pgsql-hackers
Attachments
- 0001-Tab-completion-not-listing-schema-list-for-create-al.patch (text/x-patch) patch 0001
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
Commits
-
Fix bogus tab-completion queries.
- 369398ed886d 15.0 landed