Re: [BUGS] BUG #1885: SHOW autovacuum settings tab completion broken
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 or SHOW a 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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [BUGS] BUG #1885: SHOW autovacuum settings tab completion broken
On Fri, Sep 16, 2005 at 06:02:14AM +0100, Robert Treat wrote: > PostgreSQL version: 8.1beta1 > > When doing SHOW or SHOW a 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 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
[BUGS] BUG #1885: SHOW autovacuum settings tab completion broken
The following bug has been logged online: Bug reference: 1885 Logged by: Robert Treat Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1beta1 Operating system: FC2 Description:SHOW autovacuum settings tab completion broken Details: When doing SHOW or SHOW a 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