Thread: BUG #1885: SHOW autovacuum settings tab completion broken

The following bug has been logged online:

Bug reference:      1885
Logged by:          Robert Treat
Email address:      xzilla@users.sourceforge.net
PostgreSQL version: 8.1beta1
Operating system:   FC2
Description:        SHOW autovacuum settings tab completion broken
Details:

When doing SHOW <tab><tab> or SHOW a<tab><tab> none of the autovacuum
settings come up.  I don't see anything in cvs head tab-complete.c that
stands out as being wrong, although it looks in psql like the SHOW list and
SET lists are being returned as the same thing, even though they should be
different according to the code.  Confirmed with someone on IRC that thier
autovacuum guc's didnt come up either.

On Fri, Sep 16, 2005 at 06:02:14AM +0100, Robert Treat wrote:
> PostgreSQL version: 8.1beta1
>
> When doing SHOW <tab><tab> or SHOW a<tab><tab> none of the autovacuum
> settings come up.

Are you sure you're using an 8.1beta1 psql?  I think tab completion
were fixed to read the variable list from pg_settings before 8.1beta1
was released:

http://archives.postgresql.org/pgsql-committers/2005-08/msg00151.php

Here's what I get:

test=> SHOW a<tab><tab>
add_missing_from                 authentication_timeout           autovacuum_naptime
autovacuum_vacuum_threshold
all                              autovacuum                       autovacuum_vacuum_cost_delay
archive_command                  autovacuum_analyze_scale_factor  autovacuum_vacuum_cost_limit
australian_timezones             autovacuum_analyze_threshold     autovacuum_vacuum_scale_factor

--
Michael Fuhr

On Friday 16 September 2005 09:00, Michael Fuhr wrote:
> On Fri, Sep 16, 2005 at 06:02:14AM +0100, Robert Treat wrote:
> > PostgreSQL version: 8.1beta1
> >
> > When doing SHOW <tab><tab> or SHOW a<tab><tab> none of the autovacuum
> > settings come up.
>
> Are you sure you're using an 8.1beta1 psql?  I think tab completion
> were fixed to read the variable list from pg_settings before 8.1beta1
> was released:
>
Doh!

postgres=# select version();
                                                  version
------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.1devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.3
20040412 (Red Hat Linux 3.3.3-7)

At 1 AM that sure looked like 8.1beta1 :-(   Guess that explains why the code
looked correct... course I gotta wonder about whoever it was on irc that
"confirmed" the problem for me :-)   Thanks Michael.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL