Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rJa7f-00EEwm-EE for pgsql-bugs@arkaria.postgresql.org; Sat, 30 Dec 2023 14:15:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rJa7d-000K6d-V2 for pgsql-bugs@arkaria.postgresql.org; Sat, 30 Dec 2023 14:15:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rJWQ3-00GZqo-34 for pgsql-bugs@lists.postgresql.org; Sat, 30 Dec 2023 10:18:15 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rJWPv-00Edhz-UW for pgsql-bugs@lists.postgresql.org; Sat, 30 Dec 2023 10:18:13 +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=TQhgfP2kI/k3a69X382souTSWth7rCQ5DmRkPBLIc2Y=; b=ufBihP2XBfEjURxmdEkLFnMxNL c7IHgMA3Dy/XgpbHOv9U1nLlNh/iAelMN88pR8vonTMJ+nSfcM5iH1fcdyLBA2BLT5M4sswUya1mJ LT6XrpJWnaF8TLmq+Gqo6g3FYzKuQbVhNHogZO77k8tkiadYg3y0MjTrPw2DMQsrPzV6E8cLKASJh xzdvfZb/LaXoGTvMr49+H774g6+vmDWkwvHQHEenqS8LE0F9JV6Sk82lnXN6gQE/IGN2c7RcjC++Z 1eDb2JLG5OwK0Q+bAyI65k+00wrcvLODhtj/HStqw3YZmgnolRC5T9jMImjHGRtek5EJCQ/7PDhuh XhXSIhxA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rJWPt-008Xgk-Iv for pgsql-bugs@lists.postgresql.org; Sat, 30 Dec 2023 10:18:06 +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 1rJWPp-0027CR-99 for pgsql-bugs@lists.postgresql.org; Sat, 30 Dec 2023 10:18:02 +0000 Content-Type: multipart/mixed; boundary="===============6441120437925823605==" MIME-Version: 1.0 Subject: BUG #18264: Table has type text, but query expects integer.attribute 1 of type record has wrong type To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: vojtech.benes@centrum.cz Reply-To: vojtech.benes@centrum.cz, pgsql-bugs@lists.postgresql.org Date: Sat, 30 Dec 2023 10:17:40 +0000 Message-ID: <18264-e363593d7e9feb7d@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 --===============6441120437925823605== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODI2NApMb2dnZWQgYnk6ICAgICAgICAgIFZvanTEm2NoIEJlbmXFoQpF bWFpbCBhZGRyZXNzOiAgICAgIHZvanRlY2guYmVuZXNAY2VudHJ1bS5jegpQb3N0Z3JlU1FMIHZl cnNpb246IDE2LjEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjIuMDQuMyBMVFMKRGVzY3Jp cHRpb246ICAgICAgICAKCk9uZSBwYXJ0aWN1bGFyIHF1ZXJ5IG91dHB1dHMgdW5leHBlY3RlZCBl cnJvciBpbnN0ZWFkIG9mIHJlc3VsdCBkYXRhLiBUaGlzCmJlaGF2aW91ciBpcyBzdHJhbmdlIHdo aWxlIGNoYW5nZSBvZiBvcmRlciBvZiBjb2x1bW5zIHNlZW1zIHRvIGF2b2lkIGlzc3VlLgpBbHNv IHJlbW92aW5nIERJTlNUSU5DVCBrZXl3b3JkIGluIGZpcnN0IGNvbHVtbiBvciBXSEVSRSBzdGF0 ZW1lbnQgaW4gc2Vjb25kCmNvbHVtbiBhbHNvIHNvbWVob3cgYXZvaWQgaXNzdWUuIEkgd2FzIGFi bGUgdG8gaXNvbGF0ZSBwYXJ0IHRoYXQgY2F1c2VzCnByb2JsZW1zIGFuZCB3cml0ZSBmb2xsb3dp bmcgdGVzdCBjYXNlOiANCg0KU0VMRUNUDQpzdHJpbmdfYWdnKERJU1RJTkNUICdhJywgJywgJykg YWdnLA0Kc3VtKA0KICAoDQogICAgU0VMRUNUIHN1bSgxKQ0KICAgIEZST00gKFNFTEVDVCBpZCBG Uk9NIHVubmVzdChhcnJheVsxXSkgaWQpIEINCiAgICBXSEVSRSAgQS5pZCA9IEIuaWQNCiAgKQ0K KSBzdW0NCkZST00gKFNFTEVDVCBpZCBGUk9NIHVubmVzdChhcnJheVsxXSkgaWQpIEE7DQoNCkJv dGggcHNxbCBhbmQgcGdhZG1pbiBvdXRwdXRzIHRoaXM6DQpFUlJPUjogIGF0dHJpYnV0ZSAxIG9m IHR5cGUgcmVjb3JkIGhhcyB3cm9uZyB0eXBlDQpTUUwgc3RhdHVzOiA0MjgwNA0KRGV0YWlsOiBU YWJsZSBoYXMgdHlwZSB0ZXh0LCBidXQgcXVlcnkgZXhwZWN0cyBpbnRlZ2VyLg0KDQpCZWhhdmlv dXIgd2FzIHJlcHJvZHVjZWQgaW4gbXVsdGlwbGUgdXBkYXRlZCBjbGVhbiBlbnZpcm9ubWVudHM6 DQpQb3N0Z3JlU1FMIDE2LjEgKFVidW50dSAxNi4xLTEucGdkZzIyLjA0KzEpIG9uIHg4Nl82NC1w Yy1saW51eC1nbnUsIGNvbXBpbGVkCmJ5IGdjYyAoVWJ1bnR1IDExLjQuMC0xdWJ1bnR1MX4yMi4w NCkgMTEuNC4wLCA2NC1iaXQNClBvc3RncmVTUUwgMTdkZXZlbCAoVWJ1bnR1IDE3fn5kZXZlbC0x LnBnZGcyMi4wNCt+MjAyMzEyMjcuMjIzNS5nNTgwNTRkZSkgb24KeDg2XzY0LXBjLWxpbnV4LWdu dSwgY29tcGlsZWQgYnkgZ2NjIChVYnVudHUgMTEuNC4wLTF1YnVudHUxfjIyLjA0KSAxMS40LjAs CjY0LWJpdA0KDQpIZXJlIHF1ZXJ5IHdvcmtzIGFzIGV4cGVjdGVkOg0KUG9zdGdyZVNRTCAxNC45 IChVYnVudHUgMTQuOS0xLnBnZGcyMC4wNCsxKSBvbiB4ODZfNjQtcGMtbGludXgtZ251LCBjb21w aWxlZApieSBnY2MgKFVidW50dSA5LjQuMC0xdWJ1bnR1MX4yMC4wNC4xKSA5LjQuMCwgNjQtYml0 DQpQb3N0Z3JlU1FMIDE1LjUgKFVidW50dSAxNS41LTEucGdkZzIyLjA0KzEpIG9uIHg4Nl82NC1w Yy1saW51eC1nbnUsIGNvbXBpbGVkCmJ5IGdjYyAoVWJ1bnR1IDExLjQuMC0xdWJ1bnR1MX4yMi4w NCkgMTEuNC4wLCA2NC1iaXQNCg0KV2hpbGUgc2ltcGxpZmlpbmcgcXVlcnkgZm9yIHRlc3QgY2Fz ZSBJIGFsc28gbWFuYWdlZCB0byBwcm9kdWNlIHF1ZXJ5IHdpdGgKc2xpZ3RobHkgZGlmZmVyZW50 IGtpbmQgb2YgYmVoYXZpb3VyLiBJIGJlbGlldmUgaXQgaXMgcmVsYXRlZCB0byBjYXNlIGFib3Zl CmFuZCBzbGlnaHQgY2hhbmdlIHByb2R1Y2VzIHNhbWUgZXJyb3JzOg0KRVJST1I6ICBhdHRyaWJ1 dGUgbnVtYmVyIDMgZXhjZWVkcyBudW1iZXIgb2YgY29sdW1ucyAyDQpTUUwgc3RhdHVzOiBYWDAw MA0KDQpDUkVBVEUgVEVNUE9SQVJZIFRBQkxFIF90bXBfYSBPTiBDT01NSVQgRFJPUCBBUw0KU0VM RUNUICogRlJPTSAoDQogICB2YWx1ZXMgKDEsIGZhbHNlKQ0KKSBhcyB0KGlkLCBib29sKTsNCg0K U0VMRUNUIA0Kc3RyaW5nX2FnZyhkaXN0aW5jdCAnYScsICcsICcpLA0Kc3VtKA0KCUNBU0UgDQoJ V0hFTiBCLmJvb2wgSVMgTk9UIEZBTFNFIEFORCBCLmlkIElTIE5PVCBOVUxMIFRIRU4gMCANCglF TFNFICgNCgkJU0VMRUNUIHN1bSgxKQ0KCQlGUk9NIChTRUxFQ1QgaWQgRlJPTSB1bm5lc3QoYXJy YXlbMV0pIGlkKSBDIA0KCQlXSEVSRSBBLmlkID0gQy5pZA0KCSkgRU5EDQopDQpGUk9NIChTRUxF Q1QgaWQgRlJPTSB1bm5lc3QoYXJyYXlbMV0pIGlkKSBBDQpDUk9TUyBKT0lOIF90bXBfYSBCCgo= --===============6441120437925823605==--