Skip site navigation (1) Skip section navigation (2)

Re: Use of backslash in tsearch2

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Use of backslash in tsearch2
Date: 2006-08-22 07:50:14
Message-ID: 44EAB736.8020405@sigaev.ru (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
>> 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(at)sigaev(dot)ru
                                                    WWW: http://www.sigaev.ru/

In response to

Responses

pgsql-hackers by date

Next:From: Alban HertroysDate: 2006-08-22 09:50:26
Subject: Re: Queries joining views
Previous:From: Lukas Kahwe SmithDate: 2006-08-22 07:49:28
Subject: Re: news server does not respond

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-08-22 12:06:08
Subject: Re: COPY view
Previous:From: Magnus HaganderDate: 2006-08-22 07:40:30
Subject: Re: [HACKERS] Unable to post to -patches (was: Visual C++ build files)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group