Обсуждение: 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?

The last place I see it is:

http://www.postgresql.org/docs/9.4/interactive/test-parser.html

I do not see it in the 9.5 contrib modules:

http://www.postgresql.org/docs/9.5/interactive/contrib.html

Aah, looking at the Release Notes for 9.5:

http://www.postgresql.org/docs/9.5/interactive/release-9-5.html

Move dummy_seclabel, test_shm_mq, test_parser, and worker_spi from
contrib to src/test/modules (Álvaro Herrera)

These modules are only meant for server testing, so they do not need to
be built or installed when packaging PostgreSQL.

So if you are building from source you can go there to build the module.

> cnpusr
> 2015-01-15


--
Adrian Klaver
adrian.klaver@aklaver.com

閬閬イふ 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

What is zhparser anyway?  There is one such thing at
https://github.com/amutu/zhparser
but I don't think it depends on test_parser in any way.

Note this:

>  CREATE EXTENSION zhparser
>  say:
>  ERROR:  syntax error at or near ""
> LINE 1: CREATE EXTENSION zhparser
>         ^

My editor shows a "<feff>" marker between the double quotes in that
error message -- you sent a byte-order mark (BOM) in your CREATE
EXTENSION command, which is wrong.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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