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 1nqZ27-0007y1-RD for pgsql-bugs@arkaria.postgresql.org; Mon, 16 May 2022 11:37:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nqZ26-0000Bo-Pc for pgsql-bugs@arkaria.postgresql.org; Mon, 16 May 2022 11:37:02 +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 1nqWyS-0005df-HV for pgsql-bugs@lists.postgresql.org; Mon, 16 May 2022 09:25:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nqWyP-0005yV-RQ for pgsql-bugs@lists.postgresql.org; Mon, 16 May 2022 09:25:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=uNiKiXTLjNezK9NJ7GWLqZDdFOJaMEL2yO7qeQ8UW2g=; b=qrBQPHQUnNwT01hd5gakNCmWCz WeZHn55J8fxoGjHuRND+WBlnEshnmuwcWFcA+Vc7qUMs6mxt7lTdqVehJeed4xMSPI+gAQzl2WLYW x+7Qdnlp2wAl7OKKVJj09e0hso9u4393oU6NJOGPzzPpnKx/ZqOWhalakWsHJEYZjgvrPYd3u4Lds oLwbUW99EAuPe/r0fPW1kqmSM5E5l5hVGhPDiXdrpLBspmAjG6OEwlfUqwBXLQkkAzo04bqpWRGPI 7OTyRb9RzkgB8+Goyr09E3lInEzABtxt8H1FsaxMJG4QCJevR2zWH+siNYshcoHIwtVRndZDnSE5f VAJfpnvg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nqWyO-0007Tr-NA for pgsql-bugs@lists.postgresql.org; Mon, 16 May 2022 09:25:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1nqWyO-006y3A-7G for pgsql-bugs@lists.postgresql.org; Mon, 16 May 2022 09:25:02 +0000 Content-Type: multipart/mixed; boundary="===============6227231949018826865==" MIME-Version: 1.0 Subject: BUG #17483: postgres_fdw used with text to_tsvector and custom search configuration To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: equincerot@yahoo.fr Reply-To: equincerot@yahoo.fr, pgsql-bugs@lists.postgresql.org Date: Mon, 16 May 2022 09:25:01 +0000 Message-ID: <17483-795757fa99607659@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6227231949018826865== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQ4MwpMb2dnZWQgYnk6ICAgICAgICAgIEVtbWFudWVsIFF1aW5jZXJv dApFbWFpbCBhZGRyZXNzOiAgICAgIGVxdWluY2Vyb3RAeWFob28uZnIKUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMi4xMApPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAg CgpIZWxsbyBldmVyeW9uZSwNCg0KSSBoYXZlIGFuIGlzc3VlIHdpdGggdGhlIGV2YWx1YXRpb24g b2YgdG9fdHN2ZWN0b3IgYW5kIGN1c3RvbSBzZWFyY2gKY29uZmlndXJhdGlvbiB0aHJvdWdoIGZv cmVpZ24gZGF0YSB3cmFwcGVyIChmcm9tIFBHIHRvIFBHKS4NClRoZSBpc3N1ZXMgb2NjdXJzIG9u IFBHIDEyLjEwIGJ1dCBhbHNvIHdpdGggdGhlIGxhdGVzdCBkb2NrZXIgaW1hZ2Ugb2YgUEcKMTQu Mi4NCkhlcmUgaXMgYSBzbmlwcGV0IHRoYXQgcmVwcm9kdWNlcyB0aGUgaXNzdWUsIHdpdGggdHdv IHdvcmthcm91bmRzOg0KDQpjcmVhdGUgZGF0YWJhc2UgbG9jYWw7DQpjcmVhdGUgZGF0YWJhc2Ug cmVtb3RlOw0KDQpcYyByZW1vdGUNCiAgICBDUkVBVEUgVEFCTEUgcHVibGljLmZvbyAoaSBpbnQs IGNvbW1lbnQgdGV4dCk7DQogICAgQ1JFQVRFIEVYVEVOU0lPTiBJRiBOT1QgRVhJU1RTIHVuYWNj ZW50IFdJVEggU0NIRU1BIHB1YmxpYzsNCiAgICBDUkVBVEUgVEVYVCBTRUFSQ0ggQ09ORklHVVJB VElPTiBwdWJsaWMuY3VzdG9tX3NlYXJjaCAoUEFSU0VSID0KcGdfY2F0YWxvZy5kZWZhdWx0KTsN CiAgICBBTFRFUiBURVhUIFNFQVJDSCBDT05GSUdVUkFUSU9OIGN1c3RvbV9zZWFyY2ggQUREIE1B UFBJTkcgRk9SIHdvcmQgV0lUSApwdWJsaWMudW5hY2NlbnQsIHNpbXBsZTsNCiAgICBBTFRFUiBU RVhUIFNFQVJDSCBDT05GSUdVUkFUSU9OIGN1c3RvbV9zZWFyY2ggQUREIE1BUFBJTkcgRk9SIGFz Y2lpd29yZAp3aXRoIHNpbXBsZTsNCiAgICBJTlNFUlQgSU5UTyBmb28gU0VMRUNUIGdlbmVyYXRl X3NlcmllcygxLDEwMDAwMDApLCAnc29tZSBjb21tZW50JzsNClxjIGxvY2FsDQpDUkVBVEUgRVhU RU5TSU9OIElGIE5PVCBFWElTVFMgdW5hY2NlbnQgV0lUSCBTQ0hFTUEgcHVibGljOw0KQ1JFQVRF IEVYVEVOU0lPTiBwb3N0Z3Jlc19mZHc7DQpDUkVBVEUgU0VSVkVSIElGIE5PVCBFWElTVFMgZmR3 X3JlbW90ZQ0KICAgIEZPUkVJR04gREFUQSBXUkFQUEVSIHBvc3RncmVzX2Zkdw0KICAgIE9QVElP TlMgKGhvc3QgJ2xvY2FsaG9zdCcsIHBvcnQgJzU0MzInLCBkYm5hbWUgJ3JlbW90ZScpOw0KQ1JF QVRFIFVTRVIgTUFQUElORyBJRiBOT1QgRVhJU1RTIEZPUiBDVVJSRU5UX1VTRVIgU0VSVkVSIGZk d19yZW1vdGUgT1BUSU9OUwooIHVzZXIgJ3Bvc3RncmVzJyk7DQpJTVBPUlQgRk9SRUlHTiBTQ0hF TUEgcHVibGljIEZST00gU0VSVkVSIGZkd19yZW1vdGUgSU5UTyBwdWJsaWMgT1BUSU9OUwooaW1w b3J0X2RlZmF1bHQgJ3RydWUnKTsNCg0KU0VMRUNUIGksIHRvX3RzdmVjdG9yKCdjdXN0b21fc2Vh cmNoJzo6cmVnY29uZmlnLCBjb21tZW50KQ0KRlJPTSBmb28NCndoZXJlIGxlbmd0aCh0b190c3Zl Y3RvcignY3VzdG9tX3NlYXJjaCc6OnJlZ2NvbmZpZywgY29tbWVudCkpID4gMDsNCi0tIEVSUk9S OiAgdGV4dCBzZWFyY2ggY29uZmlndXJhdGlvbiAiY3VzdG9tX3NlYXJjaCIgZG9lcyBub3QgZXhp c3QNCi0tIExJR05FIDEgOiBTRUxFQ1QgaSwgdG9fdHN2ZWN0b3IoJ2N1c3RvbV9zZWFyY2gnOjpy ZWdjb25maWcsIGNvbW1lbnQpDQotLSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIF4N Cg0KQ1JFQVRFIFRFWFQgU0VBUkNIIENPTkZJR1VSQVRJT04gcHVibGljLmN1c3RvbV9zZWFyY2gg KFBBUlNFUiA9CnBnX2NhdGFsb2cuZGVmYXVsdCk7DQpBTFRFUiBURVhUIFNFQVJDSCBDT05GSUdV UkFUSU9OIGN1c3RvbV9zZWFyY2ggIEFERCBNQVBQSU5HIEZPUiB3b3JkIFdJVEgKcHVibGljLnVu YWNjZW50LCBzaW1wbGU7DQpBTFRFUiBURVhUIFNFQVJDSCBDT05GSUdVUkFUSU9OIGN1c3RvbV9z ZWFyY2ggQUREIE1BUFBJTkcgRk9SIGFzY2lpd29yZCB3aXRoCnNpbXBsZTsNCg0KLS0gTm93IHRo aXMgd29ya3M6DQpTRUxFQ1QgaSwgdG9fdHN2ZWN0b3IoJ2N1c3RvbV9zZWFyY2gnOjpyZWdjb25m aWcsIGNvbW1lbnQpDQpGUk9NIGZvbzsNCg0KLS0gQnV0IHN0aWxsOg0KU0VMRUNUIGksIHRvX3Rz dmVjdG9yKCdjdXN0b21fc2VhcmNoJzo6cmVnY29uZmlnLCBjb21tZW50KQ0KRlJPTSBmb28NCndo ZXJlIGxlbmd0aCh0b190c3ZlY3RvcignY3VzdG9tX3NlYXJjaCc6OnJlZ2NvbmZpZywgY29tbWVu dCkpID4gMDsNCi0tIEVSUk9SOiAgdGV4dCBzZWFyY2ggY29uZmlndXJhdGlvbiAiY3VzdG9tX3Nl YXJjaCIgZG9lcyBub3QgZXhpc3QNCi0tIENPTlRFWFRFIDogcmVtb3RlIFNRTCBjb21tYW5kOiBT RUxFQ1QgaSwgY29tbWVudCBGUk9NIHB1YmxpYy5mb28gV0hFUkUKKCh0b190c3ZlY3RvcignY3Vz dG9tX3NlYXJjaCc6OnJlZ2NvbmZpZywgY29tbWVudCkgSVMgTk9UIE5VTEwpKQ0KDQoNCi0tIEEg Zmlyc3Qgd29ya2Fyb3VuZA0KQ1JFQVRFIEZPUkVJR04gVEFCTEUgSUYgTk9UIEVYSVNUUyBwdWJs aWMuZmR3X3BnX3RzX2NvbmZpZw0KICAgICgNCiAgICAgICAgb2lkIG9pZCwNCiAgICAgICAgY2Zn bmFtZSBuYW1lDQogICAgICAgICkNCiAgICBTRVJWRVIgZmR3X3JlbW90ZQ0KICAgIE9QVElPTlMg KHNjaGVtYV9uYW1lICdwZ19jYXRhbG9nJywgdGFibGVfbmFtZSAncGdfdHNfY29uZmlnJyk7DQoN Ci0tIFRoaXMgd291bGQgd29yayBidXQgaXMgYSBiaXQgY29tcGxleA0KU0VMRUNUIGksIHRvX3Rz dmVjdG9yKCdjdXN0b21fc2VhcmNoJzo6cmVnY29uZmlnLCBjb21tZW50KQ0KRlJPTSBmb28NCndo ZXJlIGxlbmd0aCh0b190c3ZlY3Rvcigoc2VsZWN0IG9pZCBmcm9tIGZkd19wZ190c19jb25maWcg d2hlcmUgY2ZnbmFtZSA9CidjdXN0b21fc2VhcmNoJyBMSU1JVCAxKSwgY29tbWVudCkpID4gMDsN Cg0KLS0gQW4gb3RoZXIgd29ya2Fyb3VuZCAodGhhbmtzIHRvIERhbmllbCBNYXVtYXJ5KQ0KXGMg cmVtb3RlDQpBTFRFUiBUQUJMRSBmb28gQUREIENPTFVNTiB0ZXh0c2VhcmNoYWJsZV9pbmRleF9j b2wgdHN2ZWN0b3IgIEdFTkVSQVRFRApBTFdBWVMgQVMgKHRvX3RzdmVjdG9yKCdjdXN0b21fc2Vh cmNoJywgY29tbWVudCkgKSBTVE9SRUQ7DQoNClxjIGxvY2FsDQpkcm9wIGZvcmVpZ24gdGFibGUg Zm9vOw0KSU1QT1JUIEZPUkVJR04gU0NIRU1BIHB1YmxpYyBGUk9NIFNFUlZFUiBmZHdfcmVtb3Rl IElOVE8gcHVibGljIE9QVElPTlMKKGltcG9ydF9kZWZhdWx0ICd0cnVlJyk7DQpTRUxFQ1QgaSwg dGV4dHNlYXJjaGFibGVfaW5kZXhfY29sDQpGUk9NIGZvbw0Kd2hlcmUgbGVuZ3RoKHRleHRzZWFy Y2hhYmxlX2luZGV4X2NvbCkgPiAwOw0KDQpJIHdvdWxkIGV4cGVjdCB0byBiZSBhYmxlIHRvIGNh bGwgdHN2ZWN0b3Igb24gY3VzdG9tIHRleHQgY29uZmlndXJhdGlvbgp3aXRob3V0IHVzaW5nIHRo ZSB3b3JrYXJvdW5kIGRlc2NyaWJlZCBhYm92ZSwgc28gdGhhdCB0aGUgYXBwbGljYXRpb24gY2Fu CmR5bmFtaWNhbGx5IHVzZSB0aGUgc2VhcmNoIGNvbmZpZyB3aXRob3V0IGFsdGVyaW5nIHRoZSBt b2RlbCwgYW5kIHdpdGhvdXQKaGF2aW5nIHR3byBkaXN0aW5jdCB3YXlzIG9mIHdyaXRpbmcgdG9f dHN2ZWN0b3IgKG9uZSBmb3IgdGhlIHNlbGVjdCwgb25lIGZvcgp0aGUgd2hlcmUpLgoK --===============6227231949018826865==--