Re: Bug with Tsearch and tsvector - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug with Tsearch and tsvector
Date
Msg-id 10179.1272547918@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug with Tsearch and tsvector  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-bugs
Jasen Betts <jasen@xnet.co.nz> writes:
> \ is popular in URIs on some platfroms, or is URI a different beast

I hope not, because \ is explicitly disallowed by both the older and
newer versions of that RFC.

I did think of proposing that we allow \ and : in FilePath, which is
currently pretty Unix-centric:

regression=# select * from ts_debug('/foo/bar.baz');
 alias |    description    |    token     | dictionaries | dictionary |    lexemes
-------+-------------------+--------------+--------------+------------+----------------
 file  | File or path name | /foo/bar.baz | {simple}     | simple     | {/foo/bar.baz}
(1 row)

regression=# select * from ts_debug(E'C:\\foo\\bar.baz');
   alias   |   description   |  token  |  dictionaries  |  dictionary  |  lexemes
-----------+-----------------+---------+----------------+--------------+-----------
 asciiword | Word, all ASCII | C       | {english_stem} | english_stem | {c}
 blank     | Space symbols   | :\      | {}             |              |
 asciiword | Word, all ASCII | foo     | {english_stem} | english_stem | {foo}
 blank     | Space symbols   | \       | {}             |              |
 host      | Host            | bar.baz | {simple}       | simple       | {bar.baz}
(5 rows)

But that's more or less orthogonal to what URLPath should allow.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Bug with Tsearch and tsvector
Next
From: "sibal"
Date:
Subject: BUG #5441: Why Not?????