Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id DDCCE9F9C9B for ; Mon, 3 Sep 2007 16:15:31 -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 22203-03 for ; Mon, 3 Sep 2007 16:15:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 25B8C9F9BD6 for ; Mon, 3 Sep 2007 16:15:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l83JF5OR024215; Mon, 3 Sep 2007 15:15:05 -0400 (EDT) To: Alvaro Herrera cc: Gregory Stark , Oleg Bartunov , Pavel Stehule , PostgreSQL Hackers Subject: Re: tsearch filenames unlikes special symbols and numbers In-reply-to: <20070903190302.GD10282@alvh.no-ip.org> References: <162867790709021328i7771aa9jfe79268bccbf123d@mail.gmail.com> <18259.1188773171@sss.pgh.pa.us> <87y7foir7t.fsf@oxford.xeocode.com> <19257.1188777110@sss.pgh.pa.us> <20070903190302.GD10282@alvh.no-ip.org> Comments: In-reply-to Alvaro Herrera message dated "Mon, 03 Sep 2007 15:03:02 -0400" Date: Mon, 03 Sep 2007 15:15:05 -0400 Message-ID: <24214.1188846905@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/102 X-Sequence-Number: 107254 Alvaro Herrera writes: > On the other hand, this means the name has to be quoted if it would be > quoted as an SQL identifier, right? Something like that. I wasn't planning on rejecting uppercase letters, though, which would be necessary if you wanted to be strict about matching unquoted identifiers. There seems fairly clear use-case for allowing A-Z a-z 0-9 and underscore (while CVS head rejects 0-9 and underscore). There also seem to be good arguments for disallowing / \ : on various platforms, which leaves us with some other punctuation in question, as well as the whole matter of non-ASCII characters. I'm not sure whether we want to touch the idea of non-ASCII; comments? regards, tom lane