From: Florian Pflug <fgp.phlo.org@gmail.com>
To: Trevor Talbot <quension@gmail.com>
Cc: Mark Mielke <mark@mark.mielke.cc>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Gregory Stark <stark@enterprisedb.com>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: Oleg Bartunov <oleg@sai.msu.su>
Cc: Pavel Stehule <pavel.stehule@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: tsearch filenames unlikes special symbols and numbers
Date: Mon, 03 Sep 2007 20:01:08 +0200
Message-ID: <46DC4BE4.3090002@gmail.com> (raw)
In-Reply-To: <90bce5730709031002r58c8f1d8oece7692da0597ba6@mail.gmail.com>
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>
<87zm03zwqs.fsf@oxford.xeocode.com>
<8195.1188828543@sss.pgh.pa.us>
<46DC2024.4010509@mark.mielke.cc>
<90bce5730709031002r58c8f1d8oece7692da0597ba6@mail.gmail.com>
Trevor Talbot wrote:
> On 9/3/07, Mark Mielke <mark@mark.mielke.cc> wrote:
>> Tom Lane wrote:
>>> Also, ____ says that Windows throws an error for ":" in the filename,
>>> which means we needn't.
>
>> Windows doesn't fail - but it can do odd things. For example, try:
>>
>> C:\> echo hi >foo:bar
>>
>> If one then checks the directory, one finds a "foo".
>
> : is used for naming streams and attribute types in NTFS filenames.
> It's not very well-known functionality and tends to confuse people,
> but I'm not aware of any situation where it'd be a problem for read
> access. (Creation is not a security risk in the technical sense, but
> as most administrators aren't aware of alternate data streams and the
> shell does not expose them, it's effectively hidden data.)
>
> If any of you are familiar with MacOS HFS resource forks, NTFS
> basically supports an arbitrary number of named forks. A file is
> collection of one or more data streams, the single unnamed stream
> being default.
On MacOS (prior) to OSX, : was used as a directory seperator (Paths
looked like "My Harddisk:My Folder:Somefile"). In OSX, "/" is used,
but for backwards-compatibility the Finder translates "/" in filenames
to ":". So, of you do for example "touch 'my:test'" on the shell,
you see "my/test" in the Finder.
Thats another argument for staying away from : in filenames.
greetings, Florian Pflug
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: fgp.phlo.org@gmail.com, quension@gmail.com, mark@mark.mielke.cc, tgl@sss.pgh.pa.us, stark@enterprisedb.com, magnus@hagander.net, oleg@sai.msu.su, pavel.stehule@gmail.com, pgsql-hackers@postgresql.org
Subject: Re: tsearch filenames unlikes special symbols and numbers
In-Reply-To: <46DC4BE4.3090002@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox