Re: tsearch filenames unlikes special symbols and numbers

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".

Depending on *which* API one uses, the rules may change around a bit -
but whatever the situation, as long as you prefix it with a valid path,
the ":" is not going to cause you problems.

> It might still be a good idea to restrict the names to be SQL
> identifiers (ie, alphanumerics and underscores) for future-proofing,
> but it wasn't clear whether anyone but me thought that was a good
> argument. I'm willing to make it just be no-dir-separators.
>
I think it is a good argument.

Cheers,
mark

--
Mark Mielke <mark(at)mielke(dot)cc>