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 1jPQFN-0006bU-Ir for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Apr 2020 12:37:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jPQFM-0006Ga-9C for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Apr 2020 12:37:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jPMQv-0008Aa-8A for pgsql-bugs@lists.postgresql.org; Fri, 17 Apr 2020 08:33:09 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jPMQp-0007xV-Av for pgsql-bugs@lists.postgresql.org; Fri, 17 Apr 2020 08:33:06 +0000 Content-Type: multipart/mixed; boundary="===============3267726897247803055==" MIME-Version: 1.0 Subject: BUG #16373: Behavior of Temporary table creation To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: hritik122@gmail.com Reply-To: hritik122@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 17 Apr 2020 08:32:12 +0000 Message-ID: <16373-a2325a5f0e87714c@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3267726897247803055== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjM3MwpMb2dnZWQgYnk6ICAgICAgICAgIEhyaXRpayBHdXB0YQpFbWFp bCBhZGRyZXNzOiAgICAgIGhyaXRpazEyMkBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx MC4xMQpPcGVyYXRpbmcgc3lzdGVtOiAgIE1hY09TCkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSEg SGF2ZSBhIHNtYWxsIGRvdWJ0IEnigJltIGhvcGluZyB5b3UgY2FuIGhlbHAgbWUgd2l0aC4uc2lt cGx5IHB1dCwgd2hlcmUKYXJlIHRoZSB0ZW1wb3JhcnkgdGFibGVzIGNyZWF0ZWQ/IA0KDQpBRkFJ SywgdGhleSBzdGF5IGluIHRoZSBtZW1vcnkgdGlsbCB0aGUgc2l6ZSByZWFjaGVzIHRoZSB0ZW1w X2J1ZmZlcnMgbGltaXQsCmFuZCB0aGVuIHRvIHRoZSBzdG9yYWdlLCBmb3Igd2hlcmUgaXQgaXMg YWNjZXNzZWQgdXNpbmcgdGhlIHRlbXAgYnVmZmVyLCBhbmQKdGhpcyBpcyBpbmxpbmUgd2l0aCB0 aGUgYmVsb3cgUEcgZm9ydW0gYXMgd2VsbCA64oCoIA0KaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5v cmcvbWVzc2FnZS1pZC9mbGF0L0NBTXVKZzJTbkw3OEM3a1dFNEZ1OGM3TlVFRldfYmYtNEcyYzkt NFNhJTNEZk1MVjRiTHFBJTQwbWFpbC5nbWFpbC5jb20NCg0KS2luZCBvZiByZWZlcnMgaW4gdGhl IHBhcmFtZXRlciBpdHNlbGYgYXMgd2VsbDoNCuKAqGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3Jn L2RvY3MvY3VycmVudC9ydW50aW1lLWNvbmZpZy1yZXNvdXJjZS5odG1sI0dVQy1URU1QLUJVRkZF UlMNCmh0dHBzOi8vc3RhY2tvdmVyZmxvdy5jb20vcXVlc3Rpb25zLzU3MzA2ODI4L2RvZXMtcG9z dGdyZXMtc3VwcG9ydC1pbi1tZW1vcnktdGVtcC10YWJsZQ0KDQpIZXJlLCBUb20gc3VwcG9ydGVk IHRoZSB1bmRlcnN0YW5kaW5nIGFzIHdlbGwgc28gSSB3YXMgdGhpbmtpbmcgdGhpcyBpcyBob3cK aXRzIHN1cHBvc2VkIHRvIHdvcmsuIEJ1dCB0ZXN0aW5nIGl0IHJlY2VudGx5IGJvdWdodCBhIGNv bnRyYWRpY3RvcnkKYmVoYXZpb3Igd2hlcmUgdGhlIHRlbXAgdGFibGVzIGFyZSBkaXJlY3RseSBj cmVhdGVkIG9uIGRpc2sgZXZlbiBpZiB0aGV5IGFyZQp3ZWxsIGJlbG93IHRoZSB0ZW1wX2J1ZmZl ciBzaXplICh3aGljaCB0byBteSB1bmRlcnN0YW5kaW5nIHNob3VsZOKAmXZlIGJlZW4gaW4KdGhl IG1lbW9yeSkuIEJlbG93IGlzIHRoZSB0ZXN0aW5nOiDigKgNCg0KaHJpZ3VwdGE9IyBzZWxlY3Qg dmVyc2lvbigpOw0KLVsgUkVDT1JEIDEKXS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KdmVyc2lvbiB8IFBvc3RncmVTUUwgMTAuMTEgb24geDg2 XzY0LWFwcGxlLWRhcndpbjE4LjcuMCwgY29tcGlsZWQgYnkgQXBwbGUKY2xhbmcgdmVyc2lvbiAx MS4wLjAgKGNsYW5nLTExMDAuMC4zMy4xMiksIDY0LWJpdA0KDQpocmlndXB0YT0jIHNob3cgdGVt cF9idWZmZXJzOw0KLVsgUkVDT1JEIDEgXSstLS0tDQp0ZW1wX2J1ZmZlcnMgfCA4TUINCg0KaHJp Z3VwdGE9IyBjcmVhdGUgdGVtcG9yYXJ5IHRhYmxlIGhnMSAoaWQgaW50KTsNCkNSRUFURSBUQUJM ReKAqA0KRXhwYW5kZWQgZGlzcGxheSBpcyBvbi4NCg0KaHJpZ3VwdGE9IyBzZWxlY3QgKiBmcm9t IHBnX2NsYXNzIHdoZXJlIHJlbG5hbWUgbGlrZSAnaGcxJzsNCi1bIFJFQ09SRCAxIF0tLS0tLS0t Ky0tLS0tLQ0KcmVsbmFtZSAgICAgICAgICAgICB8IGhnMQ0KcmVsbmFtZXNwYWNlICAgICAgICB8 IDU3NTg1DQpyZWx0eXBlICAgICAgICAgICAgIHwgNTc1ODkNCi4uDQpyZWxmaWxlbm9kZSAgICAg ICAgIHwgNTc1ODcNCi4uDQpocmlndXB0YT0jIHNlbGVjdCBwZ19yZWxhdGlvbl9maWxlcGF0aCg1 NzU4Nyk7DQotWyBSRUNPUkQgMSBdLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0NCnBnX3Jl bGF0aW9uX2ZpbGVwYXRoIHwgYmFzZS8zMjk0NC90M181NzU4Nw0KDQojaW5zZXJ0ZWQgZmV3IHJl Y29yZHMgOiDigKhocmlndXB0YT0jIGluc2VydCBpbnRvIGhnMSB2YWx1ZXMgKGdlbmVyYXRlX3Nl cmllcygxLDEwMDAwMCkpOw0KSU5TRVJUIDAgMTAwMDAwDQoNCmhyaWd1cHRhPSMgXGR0Kw0KTGlz dCBvZiByZWxhdGlvbnMNCi1bIFJFQ09SRCAxIF0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KU2NoZW1h ICAgICAgfCBwZ190ZW1wXzMNCk5hbWUgICAgICAgIHwgaGcxDQpUeXBlICAgICAgICB8IHRhYmxl DQpPd25lciAgICAgICB8IGhyaWd1cHRhDQpTaXplICAgICAgICB8IDM5MjAga0INCg0KSGVyZSB0 aGUgc2l6ZSBpcyB+My44IE1CIGFuZCBzaG91bGTigJl2ZSBiZWVuIGluIG1lbW9yeSBhcyBpdHMg c3RpbGwgd2l0aGluCnRlbXBfYnVmZmVycywgYnV0IHRoZSBmaWxlIGlzIGFjdHVhbGx5IGNyZWF0 ZWQgb24gZGlzayB3aXRoIDMuOCBNQiBzaXplIChhbmQKaW5jcmVhc2VzIGFzIEkgaW5zZXJ0IHRo ZSByZWNvcmRzKS4gdGhpcyBzaG91bGTigJl2ZSBiZWVuIHRoZSBiZWhhdmlvciBhZnRlcgp0aGUg c2l6ZSBleGNlZWRzIDggTUIgKHRlbXBfYnVmZmVycykNCg0KOGM4NTkwMjFjZjMzOjMyOTQ0IGhy aWd1cHRhJCBscyAtbGhyIHwgaGVhZCAtMw0KdG90YWwgMzM0NTYNCi1ydy0tLS0tLS0gIDEgaHJp Z3VwdGEgIGFkbWluICAgIDI0SyBBcHIgMTYgMTc6MDQgdDNfNTc1ODdfZnNtDQotcnctLS0tLS0t ICAxIGhyaWd1cHRhICBhZG1pbiAgIDMuOE0gQXByIDE2IDE3OjA1IHQzXzU3NTg3DQoNClNvIG15 IHF1ZXN0aW9ucyBhcmU6IOKAqA0KLSB3aHkgYXJlIHRlbXAgdGFibGVzIGNyZWF0aW5nIGZpbGVz IGluIHRoZSBkaXNrIHdoZW4gdGhlcmUgdGhlIHNpemUgaXMKYWN0dWFsbHkgbGVzcyB0aGFuIHRo ZSBtZW1vcnkgbGltaXQgKHRlbXBfYnVmZmVycykg4oCUIFBsZWFzZSBub3RlIHRoYXQgdGhlcmUK aXMgb25seSBvbmUgdGVtcCB0YWJsZSBmb3IgdGhlIHNlc3Npb24gKGFuZCBub3RoaW5nIGVsc2Ug Y29uc3VtaW5nIHRoZQp0ZW1wX2J1ZmZlcnMpDQoNCi0gQW5vdGhlciBxdWVzdGlvbiBJIGFtIGNv bmNlcm5lZCB3aXRoIGlzIHRoYXQgYXMgVG9tIG1lbnRpb25lZCwg4oCcdG9hc3QKdGFibGUgaXMg YWxzbyB0ZW1w4oCdLiBTbyB0ZWNobmljYWxseSBhY2Nlc3MgdG8gdG9hc3QgdGFibGVzIGFyZSBk b25lIHRocm91Z2gKdGVtcCBidWZmZXJzIHJhdGhlciB0aGFuIHRoZSBzaGFyZWQgYnVmZmVyPyBI b3cgZG9lcyB0aGF0IHdvcmsuLiBiZWNhdXNlIHdlCndvdWxkIG5lZWQgdG8gcHVsbCB1cCBwYWdl cyBmb3IgdGhlIHJlbGF0aW9uIGluIHNoYXJlZCBidWZmZXIgdG8gYWNjZXNzIGl0LApidXQgdGhl eSBtaWdodCBoYXZlIGFzc29jaWF0ZWQgdG9hc3QgdGFibGVzIGFzIHdlbGwuIEFyZSBhY2Nlc3Mg dG8gdGhlIGRhdGEKaW4gdGhvc2UgdG9hc3QgdGFibGVzIGRvbmUgc2VwYXJhdGVseSBpbiB0ZW1w IGJ1ZmZlcnM/IA0KPT0+IGhhcyBhIGRpc2N1c3Npb24gb24gdGhpcyBhbmQgaXQgc2VlbXMgbGlr ZSB0aGUgbWVudGlvbmVkIHJlZmVyZW5jZSBpcwpmb3IgdG9hc3QgdGFibGVzIGFzc29jaWF0ZWQg d2l0aCB0ZW1wIHRhYmxlcyBvbmx5LCB3aGljaCBtYWtlcyBzZW5zZS4gaSdkCmp1c3QgbGlrZSB0 byByZS1jb25maXJtIHRoZSBzdGF0ZW1lbnQuLg0KDQpUaGFua3Mgc28gbXVjaCBmb3IgdGhlIGhl bHAhCgo= --===============3267726897247803055==--