Thread: BUG #17183: missing websearch_to_tsquery

The following bug has been logged on the website:

Bug reference:      17183
Logged by:          budi
Email address:      sampah_budi@hotmail.com
PostgreSQL version: 13.4
Operating system:   ubuntu 18.0.4 arm64
Description:

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?

thanks

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?