psql tab completion bug for ALL IN TABLESPACE - Mailing list pgsql-hackers

Hi all,

I just bumped into the following thing while looking again at Thomas'
patch for psql tab completion:
--- a/src/bin/psql/tab-complete.c
+++ b/src/bin/psql/tab-complete.c
@@ -1040,7 +1040,7 @@ psql_completion(const char *text, int start, int end)
                         pg_strcasecmp(prev5_wd, "IN") == 0 &&
                         pg_strcasecmp(prev4_wd, "TABLESPACE") == 0 &&
                         pg_strcasecmp(prev2_wd, "OWNED") == 0 &&
-                        pg_strcasecmp(prev4_wd, "BY") == 0)
+                        pg_strcasecmp(prev_wd, "BY") == 0)
        {
                COMPLETE_WITH_QUERY(Query_for_list_of_roles);
This should be backpatched, attached is the needed patch.

Regards,
--
Michael