support fix query_id for temp table

From: ma lz <ma100(at)hotmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: support fix query_id for temp table
Date: 2024-02-01 07:37:32
Message-ID: OSZP286MB2253413D25A5D93BEA4F6459F2432@OSZP286MB2253.JPNP286.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

session 1:
create temp table ttt ( a int );
insert into ttt values(3); -- query_id is XXX from pg_stat_activity

session 2:
create temp table ttt ( a int );
insert into ttt values(3); -- 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2024-02-01 08:46:36 Re: support fix query_id for temp table
Previous Message Laurenz Albe 2024-02-01 07:36:06 Re: Postgresql BUG / Help Needed