Horton
Menu

support fix query_id for temp table

ma lz <ma100@hotmail.com>

View thread
From: ma lz <ma100@hotmail.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2024-02-01T07:37:32Z
Lists: pgsql-hackers, 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?

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Use relation name instead of OID in query jumbling for RangeTblEntry

  2. Fix two issues with custom_query_jumble in gen_node_support.pl

  3. pg_stat_statements: Add more tests with temp tables and namespaces

  4. Add support for custom_query_jumble as a node field attribute