Re: 回复: [GENERAL] about test_parser installation failure problem(PostgreSQL in 9.5.0)? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: 回复: [GENERAL] about test_parser installation failure problem(PostgreSQL in 9.5.0)?
Date
Msg-id 56A2588E.4060803@aklaver.com
Whole thread Raw
In response to about test_parser installation failure problem(PostgreSQL in 9.5.0)?  ("閬閬イふ" <paaple@foxmail.com>)
List pgsql-general
On 01/21/2016 11:55 PM, 閬閬イふ wrote:

Ccing list, not because I have an answer, but to put it front of folks
that might.
>   thank you postgresql!
>      create EXTENSION zhparser Solved.beacause the config file is utf8 +
> bom,change file encoding  ok
> but query in pgAdmin III noresult,pgsql say:
> NOTICE:  text-search query contains only stop words or doesn't contain
> lexemes, ignored
> and pg_log info LOCATION:  clean_fakeval, tsquery_cleanup.c:287
> STATEMENT:
>   select to_tsquery('chinesecfg','鏈嶅姟缇や紬?);
> my execute real command sql is "select to_tsquery('chinesecfg','服务群众');"
> why log file is garbled.
>
> ------------------ 原始邮件 ------------------
> *发件人:* "Adrian Klaver";<adrian.klaver@aklaver.com>;
> *发送时间:* 2016年1月20日(星期三) 凌晨0:20
> *收件人:* "閬閬イふ"<paaple@foxmail.com>;
> "pgsql-bugs"<pgsql-bugs@postgresql.org>;
> "pgsql-general"<pgsql-general@postgresql.org>;
> "pgsql-hackers"<pgsql-hackers@postgresql.org>;
> *主题:* Re: [GENERAL] about test_parser installation failure
> problem(PostgreSQL in 9.5.0)?
>
> On 01/14/2016 06:51 PM, 閬閬イふ wrote:
>  > hi postgreSql !
>  >      test_parser install is ok (postgresql 9.2.4)
>  >     but at (postgresql 9.5.0) failure?
>  > why?the postgresql say:
>  > CREATE EXTENSION zhparser
>  > say:
>  > ERROR:  syntax error at or near ""
>  > LINE 1: CREATE EXTENSION zhparser
>  >          ^
>  > ********** 错误 **********
>  > ERROR: syntax error at or near ""
>  > SQL 状态: 42601
>  > 字符:1
>  > CREATE EXTENSION test_parser FROM unpackaged
>  > ERROR:  function testprs_start(internal, integer) does not exist
>  > ********** 错误 **********
>  > ERROR: function testprs_start(internal, integer) does not exist
>  > SQL 状态: 42883
>  > 9.5.0 Not supported ?
>  > can help me?
>



--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: david.turon@linuxbox.cz
Date:
Subject: Strange/Correct? behavior of SELECT FOR UPDATE
Next
From: Adrian Klaver
Date:
Subject: Re: Variable not found