BUG #17183: missing websearch_to_tsquery

On Wed, Sep 8, 2021 at 2:56 PM PG Bug reporting form
<noreply@postgresql.org> wrote:

I'm using the arm64 version of postgresql 13.4 - but it doesn't have
websearch_to_tsquery function
On my other computer, I'm using posgresql 13 (on x86_64) and it has that
function
Is this a bug or I did something wrong?
If it is a bug, is it going to be fixed soon?

How exactly are you checking that the function exists or not? What
does this query returns on your arm server?

select count(*) from pg_proc where proname = 'websearch_to_tsquery';

Please keep the list in copy, and avoid top posting.

On Wed, Sep 8, 2021 at 4:26 PM Budi Setiawan <sampah_budi@hotmail.com> wrote:

My bad for not providing more detail

I ran that query

select count(*) from pg_proc where proname = 'websearch_to_tsquery';
count
-------
0
(1 row)

Can you try doing "REINDEX TABLE pg_proc;" and try again? If you
still get no match, can you try the same query on "postgres" and
"template1" databases?

________________________________
From: Julien Rouhaud <rjuju123@gmail.com>
Sent: Friday, September 10, 2021 4:06 AM
To: Budi Setiawan <sampah_budi@hotmail.com>; PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17183: missing websearch_to_tsquery

Please keep the list in copy, and avoid top posting.

On Wed, Sep 8, 2021 at 4:26 PM Budi Setiawan <sampah_budi@hotmail.com> wrote:

My bad for not providing more detail

I ran that query

select count(*) from pg_proc where proname = 'websearch_to_tsquery';
count
-------
0
(1 row)

Can you try doing "REINDEX TABLE pg_proc;" and try again? If you
still get no match, can you try the same query on "postgres" and
"template1" databases?

I've tried to reindex & query on both on postgres & template1 database

Unfortunately, I still got the same result

thanks