Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id CD2E29F9FC9 for ; Mon, 3 Sep 2007 10:47:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 53035-02 for ; Mon, 3 Sep 2007 10:47:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from oxford.xeocode.com (unknown [62.232.55.118]) by postgresql.org (Postfix) with ESMTP id F0CCD9F9F2F for ; Mon, 3 Sep 2007 10:47:47 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.67) (envelope-from ) id 1ISCHD-0001FU-MV; Mon, 03 Sep 2007 14:47:39 +0100 To: "Tom Lane" Cc: "Magnus Hagander" , "Oleg Bartunov" , "Pavel Stehule" , "PostgreSQL Hackers" Subject: Re: tsearch filenames unlikes special symbols and numbers In-Reply-To: <1692.1188826039@sss.pgh.pa.us> (Tom Lane's message of "Mon\, 03 Sep 2007 09\:27\:19 -0400") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX" 35452) References: <162867790709021328i7771aa9jfe79268bccbf123d@mail.gmail.com> <18259.1188773171@sss.pgh.pa.us> <87y7foir7t.fsf@oxford.xeocode.com> <19257.1188777110@sss.pgh.pa.us> <87tzqci6tp.fsf@oxford.xeocode.com> <20070903075609.GD21833@svr2.hagander.net> <1692.1188826039@sss.pgh.pa.us> From: Gregory Stark Organization: EnterpriseDB Date: Mon, 03 Sep 2007 14:47:39 +0100 Message-ID: <87zm03zwqs.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/85 X-Sequence-Number: 107237 "Tom Lane" writes: > I'm not convinced that . is issue-free. On most if not all versions of Unix, > you are allowed to open a directory as a file and read the filenames it > contains. While I don't say it'd be easy to manage that through > tsearch, there's at least a potential for discovering the filenames > present in . and .. --- how much do we care about that? Actually I don't think that's true any more, most file systems on most Unixen do not allow it. However it appears it's still the case for Solaris so it's still a good point. I'm sure it's not true for modern versions of Linux and I thought it was false for other modern OSes -- I'm surprised it's not for Solaris even. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com