Re: date formatting and tab-complete patch - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: date formatting and tab-complete patch
Date
Msg-id 200203072048.g27KmJr08313@candle.pha.pa.us
Whole thread Raw
In response to Re: date formatting and tab-complete patch  (Manuel Sugawara <masm@fciencias.unam.mx>)
List pgsql-hackers
> > I will apply the tab completion fix.  That is a separate issue.
>
> When you are there, can you fix the `full' part of the vacuum that
> does not complete?

Done and applied. Thanks.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
? psql
Index: tab-complete.c
===================================================================
RCS file: /cvsroot/pgsql/src/bin/psql/tab-complete.c,v
retrieving revision 1.44
diff -c -r1.44 tab-complete.c
*** tab-complete.c    7 Mar 2002 04:45:53 -0000    1.44
--- tab-complete.c    7 Mar 2002 20:46:51 -0000
***************
*** 732,741 ****

  /* VACUUM */
      else if (strcasecmp(prev_wd, "VACUUM") == 0)
!         COMPLETE_WITH_QUERY("SELECT relname FROM pg_class WHERE relkind='r' and substr(relname,1,%d)='%s' UNION
SELECT'ANALYZE'::text"); 
!     else if (strcasecmp(prev2_wd, "VACUUM") == 0 && strcasecmp(prev_wd, "ANALYZE") == 0)
          COMPLETE_WITH_QUERY(Query_for_list_of_tables);
-

  /* ... FROM ... */
      else if (strcasecmp(prev_wd, "FROM") == 0)
--- 732,740 ----

  /* VACUUM */
      else if (strcasecmp(prev_wd, "VACUUM") == 0)
!         COMPLETE_WITH_QUERY("SELECT relname FROM pg_class WHERE relkind='r' and substr(relname,1,%d)='%s' UNION
SELECT'FULL'::text UNION SELECT 'ANALYZE'::text"); 
!     else if (strcasecmp(prev2_wd, "VACUUM") == 0 && (strcasecmp(prev_wd, "FULL") == 0 || strcasecmp(prev_wd,
"ANALYZE")== 0)) 
          COMPLETE_WITH_QUERY(Query_for_list_of_tables);

  /* ... FROM ... */
      else if (strcasecmp(prev_wd, "FROM") == 0)

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Current cvs source regression: create_function_1.out
Next
From: "Jim Buttafuoco"
Date:
Subject: Re: Storage Location / Tablespaces (try 3)