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 1lhTrD-0005Ig-Mg for pgsql-bugs@arkaria.postgresql.org; Fri, 14 May 2021 09:11:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lhTrB-0008Cz-Qo for pgsql-bugs@arkaria.postgresql.org; Fri, 14 May 2021 09:11:41 +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 1lhSHt-00075m-Np for pgsql-bugs@lists.postgresql.org; Fri, 14 May 2021 07:31:09 +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 1lhSHo-0000F9-Fy for pgsql-bugs@lists.postgresql.org; Fri, 14 May 2021 07:31:08 +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=ONS6rx5PbbtqFmCvFbXsOKJ5hQC7MOTE7WXqjZeAyDM=; b=SeBLGmCznD1MseckGx9H1XdI8o F/XS3M/j5am+pwYeZGTlSO9Nm+w2DhOp9hBkZg9NiddCGP74qIwyReUFPBQTmq6wFxNJv2tE663JU p9fr4Z/X5X8/b23NKdcxD1l03UWeCGM+Cx7KODPumI6lm4B2MV23rAkJHnbTEW008IrEFNJZJPBzY QnMl2Ek1S91T2lT28QQ/nqB9Jyr1Afq5yp3XurVvhRJ3bNacIpqZiTR6pdPMEcrIGTYWIdXmGYWxS WQW2xUX0EOZOvR2vccRO832JYOHaovUrZ7OlaK4apZEfkW8Axv6bMCjDuFyWWxn8iHQkQBadI3Mjs yeuksLOA==; 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 1lhSHn-0007RA-6W for pgsql-bugs@lists.postgresql.org; Fri, 14 May 2021 07:31:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lhSHl-0001AO-VF for pgsql-bugs@lists.postgresql.org; Fri, 14 May 2021 07:31:01 +0000 Content-Type: multipart/mixed; boundary="===============3775497367764079608==" MIME-Version: 1.0 Subject: BUG #17009: create temporary table with like option using same name as persistent table does not create indexes To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: misha_nagel@mail.ru Reply-To: misha_nagel@mail.ru, pgsql-bugs@lists.postgresql.org Date: Fri, 14 May 2021 07:30:08 +0000 Message-ID: <17009-b364ef2e97142a54@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 --===============3775497367764079608== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzAwOQpMb2dnZWQgYnk6ICAgICAgICAgIE1pa2hhaWwgTmFnZWwKRW1h aWwgYWRkcmVzczogICAgICBtaXNoYV9uYWdlbEBtYWlsLnJ1ClBvc3RncmVTUUwgdmVyc2lvbjog MTIuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbiB4NjQKRGVzY3JpcHRpb246ICAgICAgICAK CnRlc3Q6DQpjcmVhdGUgdGFibGUgdF90bXAgKGEgaW50KTsNCmNyZWF0ZSBpbmRleCBvbiB0X3Rt cCAoYSk7DQpjcmVhdGUgdGVtcG9yYXJ5IHRhYmxlIHRfdG1wIChsaWtlIHRfdG1wIGluY2x1ZGlu ZyBhbGwpOw0Kc2VsZWN0ICogDQpmcm9tIHBnX2NhdGFsb2cucGdfaW5kZXhlcyANCndoZXJlIHRh YmxlbmFtZSAgbGlrZSAndF90bXAlJzsNCmRyb3AgdGFibGUgdF90bXA7DQpkcm9wIHRhYmxlIHRf dG1wOw0KDQoxMi41IG91dHB1dDoNCmNlMnBnMj0+IGNyZWF0ZSB0YWJsZSB0X3RtcCAoYSBpbnQp Ow0KQ1JFQVRFIFRBQkxFDQpjZTJwZzI9PiBjcmVhdGUgaW5kZXggb24gdF90bXAgKGEpOw0KQ1JF QVRFIElOREVYDQpjZTJwZzI9PiBjcmVhdGUgdGVtcG9yYXJ5IHRhYmxlIHRfdG1wIChsaWtlIHRf dG1wIGluY2x1ZGluZyBhbGwpOw0KQ1JFQVRFIFRBQkxFDQpjZTJwZzI9PiBzZWxlY3QgKg0KY2Uy cGcyLT4gZnJvbSBwZ19jYXRhbG9nLnBnX2luZGV4ZXMNCmNlMnBnMi0+IHdoZXJlIHRhYmxlbmFt ZSAgbGlrZSAndF90bXAlJzsNCiBzY2hlbWFuYW1lIHwgdGFibGVuYW1lIHwgIGluZGV4bmFtZSAg fCB0YWJsZXNwYWNlIHwgICAgICAgICAgICAgICAgICAgICAgIAppbmRleGRlZg0KLS0tLS0tLS0t LS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIHRlc3QyICAgICAg fCB0X3RtcCAgICAgfCB0X3RtcF9hX2lkeCB8ICAgICAgICAgICAgfCBDUkVBVEUgSU5ERVgKdF90 bXBfYV9pZHggT04gcHVibGljLnRfdG1wIFVTSU5HIGJ0cmVlIChhKQ0KKDEg0YHRgtGA0L7QutCw KQ0KDQppbmRleCBvbiB0ZW1wb3JhcnkgdGFibGUgInRfdG1wIiBub3QgY3JlYXRlZA0KDQoxMi4z IGFuZCAxMy4zIG91dHB1dDoNCnBvc3RncmVzPSMgY3JlYXRlIHRhYmxlIHRfdG1wIChhIGludCk7 DQpDUkVBVEUgVEFCTEUNCnBvc3RncmVzPSMgY3JlYXRlIGluZGV4IG9uIHRfdG1wIChhKTsNCkNS RUFURSBJTkRFWA0KcG9zdGdyZXM9IyBjcmVhdGUgdGVtcG9yYXJ5IHRhYmxlIHRfdG1wIChsaWtl IHRfdG1wIGluY2x1ZGluZyBhbGwpOw0KQ1JFQVRFIFRBQkxFDQpwb3N0Z3Jlcz0jIHNlbGVjdCAq DQpwb3N0Z3Jlcy0jIGZyb20gcGdfY2F0YWxvZy5wZ19pbmRleGVzDQpwb3N0Z3Jlcy0jIHdoZXJl IHRhYmxlbmFtZSAgbGlrZSAndF90bXAlJzsNCiBzY2hlbWFuYW1lIHwgdGFibGVuYW1lIHwgIGlu ZGV4bmFtZSAgIHwgdGFibGVzcGFjZSB8ICAgICAgICAgICAgICAgICAgICAgICAKICAgaW5kZXhk ZWYNCi0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0r LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tDQogcHVibGljICAgICB8IHRfdG1wICAgICB8IHRfdG1wX2FfaWR4ICB8ICAgICAgICAg ICAgfCBDUkVBVEUgSU5ERVgKdF90bXBfYV9pZHggT04gcHVibGljLnRfdG1wIFVTSU5HIGJ0cmVl IChhKQ0KIHBnX3RlbXBfNCAgfCB0X3RtcCAgICAgfCB0X3RtcF9hX2lkeCAgfCAgICAgICAgICAg IHwgQ1JFQVRFIElOREVYCnRfdG1wX2FfaWR4IE9OIHBnX3RlbXBfNC50X3RtcCBVU0lORyBidHJl ZSAoYSkNCigyINGB0YLRgNC+0LrQuCkNCg0KYXMgZXhwZWN0ZWQgaW5kZXggb24gdGVtcG9yYXJ5 IHRhYmxlICJ0X3RtcCIgd2FzIGNyZWF0ZWQgKHNlY29uZCByb3cpDQoNCndvcmthcm91bmQgDQox LiB1c2UgZGlmZmVyZW50IHRhYmxlIG5hbWUNCmNyZWF0ZSB0ZW1wb3JhcnkgdGFibGUgdF9vdGhl cl9uYW1lIChsaWtlIHRfdG1wIGluY2x1ZGluZyBhbGwpOw0KMi4gdXNlIHNjaGVtYSBpbiBsaWtl IG9wdGlvbg0KY3JlYXRlIHRlbXBvcmFyeSB0YWJsZSB0X3RtcCAobGlrZSBwdWJsaWMudF90bXAg aW5jbHVkaW5nIGFsbCk7Cgo= --===============3775497367764079608==--