Обсуждение: BUG #17183: missing websearch_to_tsquery

Поиск
Список
Период
Сортировка

BUG #17183: missing websearch_to_tsquery

От
PG Bug reporting form
Дата:
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


Re: BUG #17183: missing websearch_to_tsquery

От
Julien Rouhaud
Дата:
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';



Re: BUG #17183: missing websearch_to_tsquery

От
Julien Rouhaud
Дата:
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?



Re: BUG #17183: missing websearch_to_tsquery

От
Budi Setiawan
Дата:



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