Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id C4976634975 for ; Wed, 6 May 2009 18:19:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43723-01-4 for ; Wed, 6 May 2009 18:19:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by mail.postgresql.org (Postfix) with ESMTP id D7F4962DBDE for ; Wed, 6 May 2009 18:19:52 -0300 (ADT) Received: from perhan.alvh.no-ip.org (200-126-118-67.bk8-dsl.surnet.cl [200.126.118.67]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id n46LRA7j026770 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 6 May 2009 14:27:14 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id CE704D4179; Wed, 6 May 2009 17:19:33 -0400 (CLT) Date: Wed, 6 May 2009 17:19:33 -0400 From: Alvaro Herrera To: Tom Lane Cc: Robert =?iso-8859-1?Q?Gravsj=F6?= , liuzg4 liuzg4 , pgsql-docs@postgresql.org, Magnus Hagander Subject: Re: [GENERAL] how to select temp table Message-ID: <20090506211933.GO4476@alvh.no-ip.org> References: <4A01CFE8.9010005@blogg.se> <20090506192354.GK4476@alvh.no-ip.org> <20090506192728.GL4476@alvh.no-ip.org> <27338.1241642808@sss.pgh.pa.us> <20090506205307.GM4476@alvh.no-ip.org> <27900.1241644298@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <27900.1241644298@sss.pgh.pa.us> User-Agent: Mutt/1.5.18 (2008-05-17) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 06 May 2009 14:27:15 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200905/7 X-Sequence-Number: 5168 Tom Lane escribió: > Alvaro Herrera writes: > > Hmm, we have another problem then, which is that GUC vars are not > > showing in the search results when you search for their names. For > > example if I search for search_path I am suggested > > http://www.postgresql.org/docs/current/static/ddl-schemas.html#DDL-SCHEMAS-PATH > > but nothing else. > > > Oh, I see the problem .. the index entry is "search_path configuration > > parameter". I think it would be better if it were > > > search_pathconfiguration parameter > > Seems like what you are describing is a bug in the search engine, > not a problem we must address by doubling the vertical space needed for > literally hundreds of index entries. Yeah, perhaps ... I think it should suggest all index entries that start with the search string, not necessarily equal. Magnus? :-) -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support