Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mTIpC-0004rQ-Ha for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Sep 2021 07:07:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mTIpB-0004Ug-BU for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Sep 2021 07:07:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mTGbN-0004NF-Qx for pgsql-bugs@lists.postgresql.org; Thu, 23 Sep 2021 04:44:54 +0000 Received: from mail-pu1apc01olkn0811.outbound.protection.outlook.com ([2a01:111:f400:febe::811] helo=APC01-PU1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mTGbK-0001GA-IH for pgsql-bugs@lists.postgresql.org; Thu, 23 Sep 2021 04:44:52 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=e1MnL2JYVcxKJE4f9R7tnl3kHXI/jNFVMj4Esje9vLOV3coKtpqdy5u8A4LRaZXE9sIgofdhj1rrp51REU0DVCSAWY8xkd/tT765DSRSCQ5rk4ki5hPxovu6h8/YhQO+6MJtA9/0jjSnc7e+tLMAQ/g6g80geKzYX010l0x7ScTDTyfdK4azDyzfLGugAn6GNPMPoLOywjWpPIGBrXGpSSZpC7huf/uejITitfub6rbLCZX/b3JIs3ZG0DmxzI/JPS1yBDQSnSfsLdAmgyN1pIvlh+HLRlpzZG6XKAZ0XzGgoKR1BldKkX+hrDDsTiGpqjqYeqxTgvOujjZAtPKDbg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=CsQpBpVb3xwnV6y6VMrwOG89/z+7u7yjF/BY3j8g5Pc=; b=Cr6oeKZY6dlPIkrpd83kxdhb60nz+lvBhBFL2X+m+JNi5/5XISn3W01kU/0fYpKkCO4WOoyTN/S4pDrGPl7wY6psDLSFZkiB1NciEEBlM6NV4NK7pQT9BIM4U2VYVUJJB9aBTHuRrpV3SCPme38fnEYjFtL4Qqta3gpDDkWQwlbTpSctExvx2VTzq71NrJDt4OiY85efIqjYkvn/+LZ4N4+cwZD7vcIqGzAQdkaByNzZMZKfy2BvbaOa18qXfD1fx7UW3xWpdIQchupLkaySskxRfSGS59iT6/41soHpHGppSMIFl24AYSXOFNuxYSy5M3nhNj7AV+BDyziSex0qRw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=CsQpBpVb3xwnV6y6VMrwOG89/z+7u7yjF/BY3j8g5Pc=; b=RdwIjBmAHwsZsvo5Ck6geFCay6IWqTE6XeFC7wENi/PtPdEQK3tdoil0gqDf5YIy0IwQqdhY94rirCXbaGlnF0cmmd9ITzOExMYRkhM7TXpBo5kZXc+hhsc/C/3EQXW7Ng3RRkEWzi/y7E6GTx6M5ZP6ko5W/xVEAoDGzD4HSS1rfRjcC9s99OZW3eeCzj+BcdzqvuDJjuvsQQGPSHdKs1OS0n9S8/02327Ilo08Ltjhp6z71MeUCAdJWqtjnX0mujgih8kgiFW/NhfTKpCY4yidOl09jT5mS0Z1qbArtR0VJ4hRfSnKATEz2mAM4BME8At1GBM0icPTFzPslOt8Dw== Received: from PS2PR06MB3573.apcprd06.prod.outlook.com (2603:1096:300:6d::14) by PSAPR06MB4150.apcprd06.prod.outlook.com (2603:1096:301:35::13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4544.15; Thu, 23 Sep 2021 04:44:46 +0000 Received: from PS2PR06MB3573.apcprd06.prod.outlook.com ([fe80::d1e3:399d:2a1e:8c1f]) by PS2PR06MB3573.apcprd06.prod.outlook.com ([fe80::d1e3:399d:2a1e:8c1f%7]) with mapi id 15.20.4544.015; Thu, 23 Sep 2021 04:44:46 +0000 From: Budi Setiawan To: Julien Rouhaud , PostgreSQL mailing lists Subject: Re: BUG #17183: missing websearch_to_tsquery Thread-Topic: BUG #17183: missing websearch_to_tsquery Thread-Index: AQHXpFaAmvUi9tHQD0KrgWhNeS7aHKuZvSSAgAAQErmAA1HUgIAUAzR5 Date: Thu, 23 Sep 2021 04:44:46 +0000 Message-ID: References: <17183-cad9d2d75515f9f1@postgresql.org> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: suggested_attachment_session_id: 857c38a2-1355-a548-5323-65cbe318e641 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [itT2Jko61Z7Dx7x7en0xyJWa35IcmOsNJI51/bdfrdQ=] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 59ff48e2-8f5a-4db6-5737-08d97e4cdea3 x-ms-traffictypediagnostic: PSAPR06MB4150: x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 7gI+2koLptQjBCvHHq/ZXyfkcCM8RMsD4SrKtwosoAaOWHzybFFypzGu1jJphWsTv7Xncs5AEr7Bcl5r4+R3f5QvoS82IrRoGlzI+81O+qQOWh6tfsc8gvWJ2ZNOhQUNJ+fE5KbwkfOvu6UA6OH6CMCMi7mfnuGORkAcBjBzBmuWYmdJC4WIv32rkzC/xFS5tz+ZokRWrN+XezRCj8uTZeLebMoutxlgDmAay4rbmuf0eXCN25lbddQYknFoTmmeqw9ehhRkLDfVUslCeGwa54V4SXHSSGKnPbQw1rYbFliafh+3sh79KWUy7AHpuAS6GB2IFiTTQ0m6V/wECmHUlFVCSlnIupVYxx0yc5TjMkF6kzFaksOPQyBleKkb+dzqI1YEu4ZrJdG2U3u4aLn0xLHkk5oYgqs+U36O03V8t/sfR7Ksog9f/Zaf4IoWWfnr x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: +MXyeYd1dBD20HMEfn/IHQAP8Mi89Dm5AnsUdX6PHIp2R1cH8QqTrLLS61VBovmPVMD+i8CvJfe6WuZ46QgbToCBEBVcJg4T07Djq/0Shz8VTYwteavmuhq2LVvWdG3OSwD9CegcekLrMaUSfgS6XA== x-ms-exchange-transport-forked: True Content-Type: multipart/alternative; boundary="_000_PS2PR06MB357375ECC339D7C32D8C2AB98CA39PS2PR06MB3573apcp_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-3174-20-msonline-outlook-d370a.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: PS2PR06MB3573.apcprd06.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 59ff48e2-8f5a-4db6-5737-08d97e4cdea3 X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Sep 2021 04:44:46.6647 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: PSAPR06MB4150 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_PS2PR06MB357375ECC339D7C32D8C2AB98CA39PS2PR06MB3573apcp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ________________________________ From: Julien Rouhaud Sent: Friday, September 10, 2021 4:06 AM To: Budi Setiawan ; PostgreSQL mailing lists 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 wr= ote: > > > > My bad for not providing more detail > > > > I ran that query > > > > select count(*) from pg_proc where proname =3D '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 --_000_PS2PR06MB357375ECC339D7C32D8C2AB98CA39PS2PR06MB3573apcp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable



From: Julien Rouhaud <= rjuju123@gmail.com>
Sent: Friday, September 10, 2021 4:06 AM
To: Budi Setiawan <sampah_budi@hotmail.com>; PostgreSQL mailin= g lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17183: missing websearch_to_tsquery
 
Please keep the list in copy, and avoid top postin= g.

> On Wed, Sep 8, 2021 at 4:26 PM Budi Setiawan <sampah_budi@hotmail.c= om> wrote:
> >
> > My bad for not providing more detail
> >
> > I ran that query
> >
> > select count(*) from pg_proc where proname =3D 'websearch_to_tsqu= ery';
> >  count
> > -------
> >      0
> > (1 row)

> Can you try doing "REINDEX TABLE pg_proc;" and try again?&nb= sp; 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 postg= res & template1 database

Unfortunately, I still got the same result

thanks
--_000_PS2PR06MB357375ECC339D7C32D8C2AB98CA39PS2PR06MB3573apcp_--