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 1rVRdl-00GwlW-Da for pgsql-general@arkaria.postgresql.org; Thu, 01 Feb 2024 07:37:42 +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 1rVRdk-002VQ2-Gs for pgsql-general@arkaria.postgresql.org; Thu, 01 Feb 2024 07:37:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rVRdj-002VPu-DN for pgsql-general@lists.postgresql.org; Thu, 01 Feb 2024 07:37:40 +0000 Received: from mail-os0jpn01olkn20800.outbound.protection.outlook.com ([2a01:111:f403:2815::800] helo=JPN01-OS0-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rVRdg-004TEf-IV for pgsql-general@lists.postgresql.org; Thu, 01 Feb 2024 07:37:37 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=c2yIdkpa0NC25IEFDXIFjBVbg5+yHsIUtqBgQdyGGK33jnT4Lwp8T2YQ0ypsynsDSIVM6tpHY2bNg4SodsEfTHOY98b1ABDHrYr7kWEXfirWXKk+24tBbriJxJmmmAdOfvXLipahQFxar84JJxDGv7lDHPj6F0gDwPKr1TacNe4CqC5dRezUfi4cYeu/EY0Fw3Ljw7iFdk+6R42Iqz5aPLj9xBp4IkeiqikL6Il/vBuiG77hqX7Xv7pmJTA4xUe6qk0ppFkTfsVRsfRv/Z71oOuWJFG+C+8sXYfIrMOVn2B+Iue/N60GKaXRU3DAlyHqR9ZgRkyD5wGeTJUhQXzzpw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=Iocl44FcKdZyc1QoifZh6JudR0x8d6ui5SpPQjjj+KM=; b=KL2FcGNsMzPkYC/ABUpSmr2wYFdVnIR6hSBxYdH9hWglC8bIrcyRv9Xy3SefGzaZuOamvJg89mpxGBO6GF7LM2TtFLqRyYY8MgzGcA6CFnjDFb9Sirl+IlOrJpVLc98uJjJMU/E+IkD1DPXKu05MMWnCQatlMWzPLcw6Ufl2lctPri0j3DDg60gGuDRTtdF9CcuwqR05s3hWmhbm5w/3hhAxdCd+UX8uhV/ZIFhE0Je2ST/zAtwcatwt58IZtwSElL1G69jny1ygsFt03JjEqkHRxP02EUdE/AOUjK2lwPi5lu77JRgowhEQxmmjwXL09oLEBXzxYJN/t1ji+8DJqw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Iocl44FcKdZyc1QoifZh6JudR0x8d6ui5SpPQjjj+KM=; b=DWDouRj9kyj1yIJTPFrMrr6KuL4PNWNsHcUY1Pgngf8dbKXqh0AFvQLe35PbwaH+wpAWj4Ze/ppN6n+M7jI0yzo9XYrkYJtquOXS3IbTnOUl7+cUmkrTGb8RcJ5rYI4+k5xWI9Nx0YkYqf9Ch8mxGDkiqSyFcBUkhx5YiY2I+aFq9R4hjMh7eNSgbMUO1ZtOIwEp+ETxxBSwzKryW23kp6yQzqPN800ZvqY+XSZdQGI8jlGGi2KbkKMBdpeENbcEKbwqRrE7NXu+1aiSfEVfcB97TAh42PQpNYKExS4Jh5UcLow8kkeLqHX/+1HktTblLa124UAG9Nb5eeELmxUZ3g== Received: from OSZP286MB2253.JPNP286.PROD.OUTLOOK.COM (2603:1096:604:18a::8) by TY3P286MB2513.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:222::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7249.23; Thu, 1 Feb 2024 07:37:32 +0000 Received: from OSZP286MB2253.JPNP286.PROD.OUTLOOK.COM ([fe80::3024:7dd4:646:f754]) by OSZP286MB2253.JPNP286.PROD.OUTLOOK.COM ([fe80::3024:7dd4:646:f754%5]) with mapi id 15.20.7249.025; Thu, 1 Feb 2024 07:37:32 +0000 From: ma lz To: "pgsql-general@lists.postgresql.org" Subject: support fix query_id for temp table Thread-Topic: support fix query_id for temp table Thread-Index: AQHaVOEaQlonZfsoYUG8zzhJxfh0Nw== Date: Thu, 1 Feb 2024 07:37:32 +0000 Message-ID: Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-tmn: [ct2T0OqSkYQs/dDd66tVPAI+dlRGK/2f] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OSZP286MB2253:EE_|TY3P286MB2513:EE_ x-ms-office365-filtering-correlation-id: e38f82ec-9515-49a8-3507-08dc22f8a69c x-ms-exchange-slblob-mailprops: Peh/bd4fmjKmGp28nTQQSZHxJMmzLOndttLLAt4bVGgbIYf9LyKo/I3monL6fniX2QQYHZtTlnUxEd6w+Yv2AVNehBeHKHNLeR2HZDPTtIhQWTvp6Zk9RMcf1Vu2izj0pfeGc1DLxC/AQ4/qvzkyPIgseCcyneCLkavqaAkahX8nI/kgqtwLdmNC1xNXaRSOlD6IkiN8kG+s9Huxk6GGEF8XMooWP6pfRNUYqBETiGpAfXs+dNLX9gZESAfOArr0ZhNcK/NZxAO0cL1ywEZYa8hibnwfWBIdYlcOVmdh3txNdn2cT1sBBpEDnZOk6ZJNxWPHC9jO9W2wI98yNBh8cDHCARKMJEUWRLLX7nUllxGt88DQ9kLhnmIZGZYoQLS700VKuekqqhXRj/AVHcTWXOquDy0P2jc0HIaXekoDjrD3/Q/MHZTgKZKSVpxmJwV2bYq76fZd5t3zDe9ccqnAa3i3/35ob0/tZyxRzaK4I+tJJRGs0Xx/QJ98eioRLJD5QFStiN55cGz3sL0FkzkUxhovSQ5g/x60K7NA9PpjpB2vnEs4eNpFIj5r/o3rztq8J2EaxcuzXOhyzf9Y8FhWFZnzmaKLE4RpHcUjPh2TDW4p03sduVscab0PQzDGCGmVYV5//NTe4CtnzuhVJA/XdMEiwMaND59mXDknp0YTDgH92boDRcN7PVeDdy01PPZxyiOuFTNjFZs= x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: lGLTJfZLimnlNjhi1BinjRC0k9OdBVXBrjHBx+8lUgfbUpetqxNzSHbROxF1TMckdstJD3b//Klxj/Ax0ETcIeYVR/ztM41JxsI8YVsOYCbIvwcYPZmncWwaDLlvAMCwE5CMw5lTCulzXxDSaYyXmtklmCZrMkpQf6bm5Hp5WeTyMhbOuWvm5Wvmexew0x1GMtz3Z5BEcRm2b156ntvRviXF5nNNgx/KJXQ4eAz/sXasJIsKHBeuyiqnTjGA33d6TS83p3nIg4KBx4zcuzrD9mB4a/vV0NWe7d5ETlUcN3tDFA3uClyiHT0ebOHzPuh29I1uQWZyyD5jqMQ3yO/hGYYwpNZ/liWxpjWqymnWAgFKwZxUSRUtosW9WM5G2u3ihWF83epU7N8r/AaNYw1IR+gaF1VoF5bsL3Gi0sjROo3yP7kv6ROTEbK+uKwVfz4ByFQTetUKyKA8kx7iEVZX9ox7ZuGgGQ5EC69z1QKB+uwbOeWEBcXhMS/AyQwdDjOpNtP6KVhFlC9NVtOCZFm15exuQY3Gfe+xa3eR0BhWr4Y1VpSE5+elfN+Pt3YwAOcO x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?gb2312?B?YUtZS0djcG1tYUluSk5PTm1uT0VuQ3BJQWN4eWM5TFAxd1dRMENhUzFuUGpC?= =?gb2312?B?WGRMaW1pREE2blpTb2ZDdEFiTWlYY3NadFROa2loZjZybEtKRlFDYnlPK0J4?= =?gb2312?B?QVlyKzRGSnFEUUNGcnBoWlkwWVVLTXVXRDl4czFzMUJjaDVTcVFKTStGdTdm?= =?gb2312?B?THoyVEdYQlVjdXNEYzJWR2lsZUE3ZzRITUNXOUs4eXROby9GQjNYanNPWith?= =?gb2312?B?ajdIMnlIVnZNWEFkYkUyV2p6M1d4UWk4M0J1K291NDZSME9KclE4c2M3cnJ5?= =?gb2312?B?S0JRbUcraWVTWkFBYjNIUzI1ckZHLysvTGYvc1FGbG9NNEgvYkNIMUY3NFFY?= =?gb2312?B?S3UrUitBbXZGbk4wSExBaHVhUHlHZmNZV3IrUXZxMHFBazJoOC9WcnpXdmMz?= =?gb2312?B?QkFOWFQ2ZUlVa3huUHZxTEtyOExNWU1Xd3o3cFBaVFh3L1lkM002ZVZUMi8y?= =?gb2312?B?K1A4dWxwVms3ZG9xQkgvTUtOZElMNEs5VlVibFkrRzBCb0liYkY2MzdHN05q?= =?gb2312?B?WGUyWktYcXNBb2V0blpEbkMxWlM5a0lMT0Y5dUZWdG5oUVQzTG1WZDRlUURS?= =?gb2312?B?UDh6by9rYit5MXRnNXk1R1ZOSnloVExyMG54VHhNUzNIMXQ2QjhBOHZkemN3?= =?gb2312?B?cnByRHZhZ3hxdytBODEwcFJoTmczdXhISTAzY3BjZXRxZjJUSnBVbnVNS1JC?= =?gb2312?B?eGt3cWYxQ0hubUlXNzVkTHE2OEkxWTdMb3lhK2pqREtrYWZFbzk1dkJ2MHgv?= =?gb2312?B?OHZ5Uk9ueGM1WWVHcGVKcVd4Y2JJZWtScFIra084NjVINWwxOW0xSS9xTjBS?= =?gb2312?B?eFlNcW8zNGxiWjBhMUxNYUJpdWVqRFBCSk9sMm1IZEdYcDBmY1FwK1ltdG9S?= =?gb2312?B?S0lWY0NUcE5Ua1kzMjAxV1VKWnJSbE9QOFZqT1FDUk5Nd00vemR2T2NBeHNK?= =?gb2312?B?TDV5aVpTZmwxVzdja3NXWW13MjZ1TUtCRXNPY1J6MjlpZnFZVjVWMWhpNEpa?= =?gb2312?B?Yks1TzQwK041UzlmSzkwYTdzTzNTTEo2NlZGejdaN2JhcW9lS0h1WGN3a0M5?= =?gb2312?B?NWpEWi9sRzhySHAzeExQK2g1L3ZXODI2RHVPc2ZDZnNta1gwK29VQ25LUmVz?= =?gb2312?B?REVPRXB5RDdadWl2bXdqd293MU1iUFJNOFhOSXNycUppcldwTlB0TXZ5V1JB?= =?gb2312?B?ZCs2ZjMxTWsxOWx2MzNwbFZ3N1dHK3RLQVVGa3M3TmZ6SDhwbHc4dFNVWDZQ?= =?gb2312?B?cktOS2Q5Sk4yeFhEKzBrcE9tVi9rN2orTHBIa2I4cXhHTFNCcld4cXpaNUxz?= =?gb2312?B?QTZXa2pHdmlvL1RhUWNJQURIcnkzVXBmT1V3ZSsxRHVXNW01K2ZrUlNLaHAv?= =?gb2312?B?VUgzV3ovQi9KUVhuSmJHNXgyeEppSVFkTDFlNHkvQU5FOG9sK1Y2UUhJL1hJ?= =?gb2312?B?Wms1ZzZqZzYraEUzdXNrQ0lHWlhDZlM5QitseVFybVBFQkRxd2VtdllyZ0Nl?= =?gb2312?B?akVHVUE4dnVGaWRqcnV5bTBoNFdVNmI4bkJRd09wN0N4TFdQejluYUFsNGNW?= =?gb2312?B?V3J4VFVPanZzSHpHdG9RU1diQllsUHJmdlpLT3pkQW1nSFJ1Szc3Tklyb20w?= =?gb2312?B?bHlMM3Rac3pqbzVxMmdGci9DZHg4VWc9PQ==?= Content-Type: multipart/alternative; boundary="_000_OSZP286MB2253413D25A5D93BEA4F6459F2432OSZP286MB2253JPNP_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-05f45.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OSZP286MB2253.JPNP286.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: e38f82ec-9515-49a8-3507-08dc22f8a69c X-MS-Exchange-CrossTenant-originalarrivaltime: 01 Feb 2024 07:37:32.1761 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY3P286MB2513 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_OSZP286MB2253413D25A5D93BEA4F6459F2432OSZP286MB2253JPNP_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 c2Vzc2lvbiAxOg0KY3JlYXRlIHRlbXAgdGFibGUgdHR0ICggYSBpbnQgKTsNCmluc2VydCBpbnRv IHR0dCB2YWx1ZXMoMyk7ICAgICAgICAgICAgICAgICAgICAgICAgIC0tIHF1ZXJ5X2lkIGlzIFhY WCAgZnJvbSBwZ19zdGF0X2FjdGl2aXR5DQoNCg0Kc2Vzc2lvbiAyOg0KY3JlYXRlIHRlbXAgdGFi bGUgdHR0ICggYSBpbnQgKTsNCmluc2VydCBpbnRvIHR0dCB2YWx1ZXMoMyk7ICAgICAgICAgICAg ICAgICAgICAgICAgLS0gcXVlcnlfaWQgaXMgWVlZICBmcm9tIHBnX3N0YXRfYWN0aXZpdHkNCg0K DQoNCkkga25vdyB0ZW1wIHRhYmxlIGhhcyBkaWZmZXJlbnQgb2lkLCBzbyBxdWVyeV9pZCBpcyBk aWZmZXJlbnQsIGlzIHRoZXJlIGEgd2F5IHRvIHVzZSB0YWJsZSBuYW1lIGZvciB0ZW1wIHRhYmxl ICBpbnN0ZWFkIG9mIG9pZD8NCg0KDQo= --_000_OSZP286MB2253413D25A5D93BEA4F6459F2432OSZP286MB2253JPNP_ Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable
session 1:
create temp table ttt= ( a int );
insert into ttt value= s(3);                    =      -- query_id is XXX  from pg_stat_activity


session 2:
create temp table ttt ( a int );
insert into t= tt values(3);                      &nbs= p; -- query_id is YYY  from pg_stat_activity



I know temp table has different oid, so query_id is different, is there= a way to use table name for temp table  instead of oid?


--_000_OSZP286MB2253413D25A5D93BEA4F6459F2432OSZP286MB2253JPNP_--