The following bug has been logged online:

Bug reference: 1885
Logged by: Robert Treat
Email address: xzilla (AT) users (DOT) 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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

On Fri, Sep 16, 2005 at 06:02:14AM +0100, Robert Treat wrote:
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...8/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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

On Friday 16 September 2005 09:00, Michael Fuhr wrote:

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly