about test_parser installation failure problem(PostgreSQL in 9.5.0)？

"=?utf-8?B?6Zas6Zas44Kk44G1?=" <paaple@foxmail.com> writes:

test_parser install is ok (postgresql 9.2.4)
but at (postgresql 9.5.0) failure？

Yes, we moved test_parser and some other only-useful-for-testing modules
from contrib to src/test/modules, which means they won't get installed in
standard installations.

regards, tom lane

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

On Sat, Jan 16, 2016 at 2:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

"=?utf-8?B?6Zas6Zas44Kk44G1?=" <paaple@foxmail.com> writes:

test_parser install is ok (postgresql 9.2.4)
but at (postgresql 9.5.0) failure？

Yes, we moved test_parser and some other only-useful-for-testing modules
from contrib to src/test/modules, which means they won't get installed in
standard installations.

Additional note: on Windows when code is compiled with MSVC, they are installed.
--
Michael

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Michael Paquier <michael.paquier@gmail.com> writes:

On Sat, Jan 16, 2016 at 2:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

Yes, we moved test_parser and some other only-useful-for-testing modules
from contrib to src/test/modules, which means they won't get installed in
standard installations.

Additional note: on Windows when code is compiled with MSVC, they are installed.

Really? Surely that's a bug.

regards, tom lane

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

On Sun, Jan 17, 2016 at 12:28 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

Michael Paquier <michael.paquier@gmail.com> writes:

On Sat, Jan 16, 2016 at 2:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

Yes, we moved test_parser and some other only-useful-for-testing modules
from contrib to src/test/modules, which means they won't get installed in
standard installations.

Additional note: on Windows when code is compiled with MSVC, they are installed.

Really? Surely that's a bug.

We are doing so to simplify the work of vcregress.pl where an instance
needs to be usually in place before running the tests.
--
Michael

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general