Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #17203: missing websearch_to_tsquery

BUG #17203: missing websearch_to_tsquery

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      17203
Logged by:          budi
Email address:      sampah_budi@hotmail.com
PostgreSQL version: 13.4
Operating system:   Ubuntu 18.04.5 Linux 5.4.0-1053-oracle aarch64
Description:

What I've done

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


REINDEX TABLE pg_proc;
on postgres & template1 database

I still get the same result


Just wondering if websearch_to_tsquery will ever be supported on aarch64

thanks

Re: BUG #17203: missing websearch_to_tsquery

From
Tom Lane
Date:
PG Bug reporting form <noreply@postgresql.org> writes:
> select count(*) from pg_proc where proname = 'websearch_to_tsquery';
> count
> -------
>      0
> (1 row)

Are you sure the server is v13?

SELECT version();

> Just wondering if websearch_to_tsquery will ever be supported on aarch64

Our aarch64 buildfarm members are all passing the regression tests
just fine.

            regards, tom lane

Re: BUG #17203: missing websearch_to_tsquery

From
Budi Setiawan
Date:


> From: Tom Lane <tgl@sss.pgh.pa.us>
> Sent: Wednesday, September 29, 2021 6:36 AM
> To: sampah_budi@hotmail.com <sampah_budi@hotmail.com>
> Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
> Subject: Re: BUG #17203: missing websearch_to_tsquery
 
> PG Bug reporting form <noreply@postgresql.org> writes:
> > select count(*) from pg_proc where proname = 'websearch_to_tsquery';
> > count
> > -------
> >      0
> > (1 row)
>
> Are you sure the server is v13?
>
> SELECT version();
>
> > Just wondering if websearch_to_tsquery will ever be supported on aarch64
>
> Our aarch64 buildfarm members are all passing the regression tests
> just fine.
>
>                         regards, tom lane

It seems that my server is v10

Apparently, there are 3 versions of posgresql running when I run sudo systemctl start postgresql

postgres 21615     1  0 19:02 ?        00:00:00 /usr/lib/postgresql/13/bin/postgres -D /var/lib/postgresql/13/main -c config_file=/etc/postgresql/13/main/postgresql.conf
postgres 21616     1  0 19:02 ?        00:00:00 /usr/lib/postgresql/12/bin/postgres -D /var/lib/postgresql/12/main -c config_file=/etc/postgresql/12/main/postgresql.conf
postgres 21617     1  0 19:02 ?        00:00:00 /usr/lib/postgresql/10/bin/postgres -D /var/lib/postgresql/10/main -c config_file=/etc/postgresql/10/main/postgresql.conf

I need to figure out how to uninstall version 10 and 12

thanks for your help