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