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 1v8Jga-00GCdj-S3 for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Oct 2025 14:38:05 +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 1v8JgX-0069Oq-8l for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Oct 2025 14:38:02 +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 1v8Ifl-005yVo-28 for pgsql-bugs@lists.postgresql.org; Mon, 13 Oct 2025 13:33:10 +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.96) (envelope-from ) id 1v8Ifj-001wC3-1j for pgsql-bugs@lists.postgresql.org; Mon, 13 Oct 2025 13:33:09 +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=4rFcb0p5rN2RvjMfRJDUbYUid5yPnuSpm70kvMJjsAI=; b=uJc/2KSlBpWigGJlZX81HqCBqO aBDoeb2YR964I92l7ql0T2C9cxE+Gyfh2NYQYgbT8IdMXu1pHrajQ3z3X9HsxmZ/X6WdPLIptBzc4 PegBWb7/P/sMSoK4shXBrUPTP+S97Ps0rwPwEV5uUPfGkYSrOFpItVMsrSg9GbKXOVQrIZ87hDfNw R3VBory7k0324AS1l6TRFd5NoofWJin0iNIImQh/6maGZ+MXM7fB3gp0+GJ8SsVLhSYqV8nO6wv0y Kb+eXdFpIUc4yk/CXO5kV71u5CJ8PkAIhFJAqvLVXZCjOGdPohnxXQCfVVJGuNAJKgfvgr68wiHzG NMTlgivw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v8Ifg-004FdE-PM for pgsql-bugs@lists.postgresql.org; Mon, 13 Oct 2025 13:33:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v8Iff-00FVkh-0h for pgsql-bugs@lists.postgresql.org; Mon, 13 Oct 2025 13:33:03 +0000 Content-Type: multipart/mixed; boundary="===============2465342591650939987==" MIME-Version: 1.0 Subject: BUG #19084: dump/restore table doesn't work with GENARETED column and custom type and cast in function To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: turon.david@seznam.cz Reply-To: turon.david@seznam.cz, pgsql-bugs@lists.postgresql.org Date: Mon, 13 Oct 2025 13:32:33 +0000 Message-ID: <19084-c3dd88cd54fff87a@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 --===============2465342591650939987== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA4NApMb2dnZWQgYnk6ICAgICAgICAgIERhdmlkIFR1cm/FiApFbWFp bCBhZGRyZXNzOiAgICAgIHR1cm9uLmRhdmlkQHNlem5hbS5jegpQb3N0Z3JlU1FMIHZlcnNpb246 IDE3LjYKT3BlcmF0aW5nIHN5c3RlbTogICBBbG1hTGludXggcmVsZWFzZSA5LjAKRGVzY3JpcHRp b246ICAgICAgICAKCkdvb2QgbW9ybmluZywKCmkgaGF2ZSBpc3N1ZSB3aXRoIGR1bXAvcmVzdG9y ZSBjdXN0b20gdHlwZSB1c2VkIGFzIEdFTkVSQVRFRCBjb2x1bW4sIGhlcmUgaXMKZXhhbXBsZToK Ci0tdGVzdCB0YWJsZSB3aXRoIEdFTkVSRUFURUQgY29sdW1uIENVU1RPTSBUWVBFIFdJVEggSU1N VVRBQkxFIEZVTkNUSU9OCgpwc3FsIHBvc3RncmVzIHBvc3RncmVzCnBzcWwgKDE3LjYpCgpDUkVB VEUgREFUQUJBU0UgdGVzdDsKXGMgdGVzdAoKLS1jdXN0b20gc2hlbGwgdHlwZSBzdG9yaW5nIGRh dGEgYXMgYmlnaW50LCBidXQgaW4ganNvbiBjYXN0IGFzIHRleHQKLS0gU0VMRUNUIGpzb25iX2J1 aWxkX29iamVjdCgndGVzdCcsMTo6dGVzdF90eXBlKTsKLS0ganNvbmJfYnVpbGRfb2JqZWN0Ci0t IC0tLS0tLS0tLS0tLS0tLS0tLQotLSB7InRlc3QiOiAiMSJ9CgoKCkNSRUFURSBUWVBFIHB1Ymxp Yy50ZXN0X3R5cGU7CgoKQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gcHVibGljLnRlc3RfdHlw ZV9pbihjc3RyaW5nKQpSRVRVUk5TIHB1YmxpYy50ZXN0X3R5cGUKTEFOR1VBR0UgaW50ZXJuYWwK SU1NVVRBQkxFClBBUkFMTEVMIFNBRkUKU1RSSUNUIEFTICRmdW5jdGlvbiRpbnQ4aW4kZnVuY3Rp b24kOwoKCgpDUkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiBwdWJsaWMudGVzdF90eXBlX291dChw dWJsaWMudGVzdF90eXBlKQpSRVRVUk5TIGNzdHJpbmcKTEFOR1VBR0UgaW50ZXJuYWwKSU1NVVRB QkxFIFBBUkFMTEVMIFNBRkUKU1RSSUNUIEFTICRmdW5jdGlvbiRpbnQ4b3V0JGZ1bmN0aW9uJDsK CgpDUkVBVEUgVFlQRSBwdWJsaWMudGVzdF90eXBlKElOUFVUPXRlc3RfdHlwZV9pbiwgT1VUUFVU PXRlc3RfdHlwZV9vdXQsCkxJS0U9YmlnaW50KTsKCgpDUkVBVEUgQ0FTVCAoYmlnaW50IEFTIHB1 YmxpYy50ZXN0X3R5cGUpIFdJVEhPVVQgRlVOQ1RJT04gQVMgSU1QTElDSVQ7CkNSRUFURSBDQVNU IChwdWJsaWMudGVzdF90eXBlIEFTIGJpZ2ludCkgV0lUSE9VVCBGVU5DVElPTiBBUyBJTVBMSUNJ VDsKCgpDUkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiBwdWJsaWMudGVzdF90eXBlX2ludF90b190 ZXN0X3R5cGUoaW50KQpSRVRVUk5TIHB1YmxpYy50ZXN0X3R5cGUKTEFOR1VBR0UgU1FMCklNTVVU QUJMRSBQQVJBTExFTCBTQUZFClNUUklDVCBBUyAkZnVuY3Rpb24kClNFTEVDVCAkMTo6YmlnaW50 Ojp0ZXN0X3R5cGU7CiRmdW5jdGlvbiQ7CgpDUkVBVEUgQ0FTVCAoaW50IEFTIHB1YmxpYy50ZXN0 X3R5cGUpIFdJVEggRlVOQ1RJT04KcHVibGljLnRlc3RfdHlwZV9pbnRfdG9fdGVzdF90eXBlKGlu dCkgQVMgSU1QTElDSVQ7CgoKCi0tIGN1c3RvbSBpbW11dGFibGUgZnVuY3Rpb24gdXNlZCBpbiBH RU5FUkFURUQgY29sdW1uIHdpdGggY3VzdG9tIHR5cGUgYW5kCmN1c3RvbSBjYXN0CkNSRUFURSBG VU5DVElPTiBmKGRhdGEganNvbmIpIFJFVFVSTlMgdGVzdF90eXBlW10gQVMgJCQgU0VMRUNUCmFy cmF5X2FnZygoZS0+PidpdGVtJyk6OnRlc3RfdHlwZSkgRlJPTSBqc29uYl9hcnJheV9lbGVtZW50 cyhkYXRhLT4ndGVzdCcpCkFTIGUgJCQgTEFOR1VBR0UgU1FMIElNTVVUQUJMRTsKCi0tIHRhYmxl IHdpdGggY3VzdG9tIHR5cGUsIHVzaW5nIGN1c3RvbSBmdW5jdGlvbiBhYm92ZSAtIHRyYW5zZmVy IGpzb24gZGF0YQp0byBhcnJheSBvZiBjdXN0b20gdHlwZQpDUkVBVEUgVEFCTEUgdGVzdChkYXRh IGpzb25iLCBudW1iZXJzIHB1YmxpYy50ZXN0X3R5cGVbXSBHRU5FUkFURUQgQUxXQVlTIEFTCihm KGRhdGEpKSBTVE9SRUQpOwoKSU5TRVJUIElOVE8gdGVzdChkYXRhKSBWQUxVRVMgKCd7InRlc3Qi OiBbeyJpdGVtIjogIjEifSwgeyJpdGVtIjogIjIifSwKeyJpdGVtIjogIjMifV19Jyk7CgpUQUJM RSB0ZXN0OwogICAgICAgICAgICAgICAgICAgICAgICAgIGRhdGEgICAgICAgICAgICAgICAgICAg ICAgICAgICB8IG51bWJlcnMKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLQogeyJ0ZXN0IjogW3siaXRlbSI6ICIxIn0sIHsi aXRlbSI6ICIyIn0sIHsiaXRlbSI6ICIzIn1dfSB8IHsxLDIsM30KCi0tZHVtcCB3b3JrcyB3ZWxs CnBnX2R1bXAgLVUgcG9zdGdyZXMgLUZjIHRlc3QgPiAvaG9tZS90ZXN0LnBnX2R1bXAKCgotLWJ1 dCByZXN0b3JlIGRvZXNuJ3Qgd29yawpwZ19yZXN0b3JlIC1VIHBvc3RncmVzIC1GYyAtZCB0ZXN0 IC9ob21lL3Rlc3QucGdfZHVtcApwZ19yZXN0b3JlOiB3aGlsZSBQUk9DRVNTSU5HIFRPQzoKcGdf cmVzdG9yZTogZnJvbSBUT0MgZW50cnkgMjA5OyAxMjU5IDE2NDg4IFRBQkxFIHRlc3QgcG9zdGdy ZXMKcGdfcmVzdG9yZTogZXJyb3I6IGNvdWxkIG5vdCBleGVjdXRlIHF1ZXJ5OiBFUlJPUjogIHR5 cGUgInRlc3RfdHlwZSIgZG9lcwpub3QgZXhpc3QKTElORSAxOiAgU0VMRUNUIGFycmF5X2FnZygo ZS0+PidpdGVtJyk6OnRlc3RfdHlwZSkgRlJPTSBqc29uYl9hcnJheV8uLi4KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIF4KUVVFUlk6ICAgU0VMRUNUIGFycmF5X2FnZygo ZS0+PidpdGVtJyk6OnRlc3RfdHlwZSkgRlJPTQpqc29uYl9hcnJheV9lbGVtZW50cyhkYXRhLT4n dGVzdCcpIEFTIGUKQ09OVEVYVDogIFNRTCBmdW5jdGlvbiAiZiIgZHVyaW5nIGlubGluaW5nCkNv bW1hbmQgd2FzOiBDUkVBVEUgVEFCTEUgcHVibGljLnRlc3QgKAogICAgZGF0YSBqc29uYiwKICAg IG51bWJlcnMgcHVibGljLnRlc3RfdHlwZVtdIEdFTkVSQVRFRCBBTFdBWVMgQVMgKHB1YmxpYy5m KGRhdGEpKSBTVE9SRUQKKTsKCgpwZ19yZXN0b3JlOiBlcnJvcjogY291bGQgbm90IGV4ZWN1dGUg cXVlcnk6IEVSUk9SOiAgcmVsYXRpb24gInB1YmxpYy50ZXN0Igpkb2VzIG5vdCBleGlzdApDb21t YW5kIHdhczogQUxURVIgVEFCTEUgcHVibGljLnRlc3QgT1dORVIgVE8gcG9zdGdyZXM7CgpwZ19y ZXN0b3JlOiBmcm9tIFRPQyBlbnRyeSA0MDQ2OyAwIDE2NDg4IFRBQkxFIERBVEEgdGVzdCBwb3N0 Z3JlcwpwZ19yZXN0b3JlOiBlcnJvcjogY291bGQgbm90IGV4ZWN1dGUgcXVlcnk6IEVSUk9SOiAg cmVsYXRpb24gInB1YmxpYy50ZXN0Igpkb2VzIG5vdCBleGlzdApDb21tYW5kIHdhczogQ09QWSBw dWJsaWMudGVzdCAoZGF0YSkgRlJPTSBzdGRpbjsKcGdfcmVzdG9yZTogd2FybmluZzogZXJyb3Jz IGlnbm9yZWQgb24gcmVzdG9yZTogMwoKSG90Zml4IGlzIG5vdyBjYXN0IGluc2lkZSBmdW5jdGlv biB0byBiaWdpbnQgaW5zdGVhZCBvZiBjdXN0b20gdGVzdF90eXBlCnR5cGUuIEFsc28gdXBncmFk ZSBwb3N0Z3JlcyAxNC0+MTcgZmFpbHMgYW5kIGlzIG1heWJlIGhhcmQgdG8gZGV0ZWN0IHRoaXMK dXNhZ2Ugc29tZXdoZXJlIGluIGRhdGFiYXNlLiBUaGFua3MgZm9yIGhlbHAuCgpEYXZpZCBUdXJv xYgKCg== --===============2465342591650939987==--