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