Re: [PATCHES] Use of backslash in tsearch2 - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: [PATCHES] Use of backslash in tsearch2
Date
Msg-id 44EAB736.8020405@sigaev.ru
Whole thread Raw
Responses Re: [PATCHES] Use of backslash in tsearch2  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers
>> Teodor, are the new attached regression results correct?  If so, I will
>> apply the patch and update the expected file.

Patch isn't full, simple test (values are took from regression.diffs):
# create table tt (tv tsvector, tq tsquery);
# insert into tt values (E'''1 \\''2''', NULL);
# insert into tt values (E'''1 \\''2''3', NULL);
# insert into tt values ( E'''1 \\''2'' 3', NULL);
# insert into tt values ( E'''1 \\''2'' '' 3'' 4 ', NULL);
# insert into tt values ( NULL, E'''1 \\''2''');
# insert into tt values ( NULL, E'''1 \\''2''');
# insert into tt values ( NULL, E'1&(''2''&('' 4''&(\\|5 | ''6 \\'' !|&'')))');
# insert into tt values ( NULL, E'1&(''2''&('' 4''&(\\|5 | ''6 \\'' !|&'')))');


and try dump table and restore:
ERROR:  syntax error
CONTEXT:  COPY tt, line 5, column tq: "'1 ''2'"

PS I'm not subscribed to -patches, so I post to -hackers

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-hackers by date:

Previous
From: Lukas Kahwe Smith
Date:
Subject: Re: news server does not respond
Next
From: "Andrew Hammond"
Date:
Subject: Re: BugTracker (Was: Re: 8.2 features status)