Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 941BF9F957C for ; Mon, 3 Sep 2007 04:26:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 44745-05-4 for ; Mon, 3 Sep 2007 04:26:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.178]) by postgresql.org (Postfix) with ESMTP id B00E29F9543 for ; Mon, 3 Sep 2007 04:26:11 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so2008900waf for ; Mon, 03 Sep 2007 00:26:10 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=BrIKOadWUVLH/9Wvdl+/WXFwT7B+OnHObCIsGrVAPoBDe5Y/ZxjX0QqXtAZwb00t3uaAhIUrO/OzJePztHXuOgbTqAV24ZaRWLZ1GRLPgfJaGzZewQvmpmkXgpKvjBvbqju7IHpXI4UheozdvBmtT2WIM8LUSxW1pBBJmQQs5dY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=avEJpSkz00hsF0y3g2mQvXfo+QmQSHs0JBR+lNCvzB0hEshr1zUTWIYfHRil2+i11baVaUg4ybuoRP2V8+Z0rbJKnjiWbrc0QnNXygzgbq0JrYcUjMN/dVMaF80SlqPagQ+XIsuoXznTnGF7Y0/VL6mUwJLFxDtCfz2xZA+qwsE= Received: by 10.114.124.1 with SMTP id w1mr312827wac.1188804369574; Mon, 03 Sep 2007 00:26:09 -0700 (PDT) Received: by 10.114.75.8 with HTTP; Mon, 3 Sep 2007 00:26:09 -0700 (PDT) Message-ID: <90bce5730709030026j6b055e0j453dd691ab139eee@mail.gmail.com> Date: Mon, 3 Sep 2007 00:26:09 -0700 From: "Trevor Talbot" To: "Gregory Stark" Subject: Re: tsearch filenames unlikes special symbols and numbers Cc: "Tom Lane" , "Oleg Bartunov" , "Pavel Stehule" , "PostgreSQL Hackers" In-Reply-To: <87tzqci6tp.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/69 X-Sequence-Number: 107221 On 9/2/07, Gregory Stark wrote: > Right, traditionally the only characters forbidden in filenames in Unix are / > and nul. If we want the files to play nice in Gnome etc then we should > restrict them to ascii since we don't know what encoding the gui expects. > > Actually I think in Windows \ : and . are problems (not allowed more than one > dot in dos). Reserved characters in Windows filenames are < > : " / \ | ? * DOS limitations aren't relevant on the OS versions Postgres supports. ...but I thought this was about opening existing files, not creating them, in which case the only relevant limitation is path separators. Any other reserved characters are going to result in no open file, rather than a security hole.