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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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/
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2006-08-22 09:50:26 | Re: Queries joining views |
Previous Message | Lukas Kahwe Smith | 2006-08-22 07:49:28 | Re: news server does not respond |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-08-22 12:06:08 | Re: COPY view |
Previous Message | Magnus Hagander | 2006-08-22 07:40:30 | Re: [HACKERS] Unable to post to -patches (was: Visual C++ build files) |