Feedback-ID: i0fe9450f:Fastmail
Date: Thu, 1 Feb 2024 17:46:36 +0900
From: Michael Paquier <michael@paquier.xyz>
To: ma lz <ma100@hotmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: support fix query_id for temp table
Message-ID: <ZbtabEYMaZ3-wcxv@paquier.xyz>
References: <OSZP286MB2253413D25A5D93BEA4F6459F2432@OSZP286MB2253.JPNP286.PROD.OUTLOOK.COM>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="kpvWAKCB5mXyl0PW"
Content-Disposition: inline
In-Reply-To: <OSZP286MB2253413D25A5D93BEA4F6459F2432@OSZP286MB2253.JPNP286.PROD.OUTLOOK.COM>
Archived-At: <https://www.postgresql.org/message-id/ZbtabEYMaZ3-wcxv%40paquier.xyz>
Precedence: bulk


--kpvWAKCB5mXyl0PW
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Feb 01, 2024 at 07:37:32AM +0000, ma lz wrote:
> session 1:
> create temp table ttt ( a int );
> insert into ttt values(3);                         -- query_id is XXX  fr=
om pg_stat_activity
>=20
> session 2:
> create temp table ttt ( a int );
> insert into ttt values(3);                        -- query_id is YYY  fro=
m pg_stat_activity
>=20
> 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?

The CREATE TABLE statements have indeed the same query ID (in 16~),
and the inserts have a different one as they touch different schemas
and relations.  That's quite an old problem, that depends on the
RangeVar attached to an InsertStmt.  I don't quite see a way to
directly handle that except by using a custom implementation in query
jumbling for this node and its RangeVar, so there is no "easy" way to
tackle that :/
--
Michael

--kpvWAKCB5mXyl0PW
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmW7WmwACgkQnvQgOdby
QH08gg//btjdjplQ8I6rkVQE5QymcUvz8PACCRq0sy88z+zF9Kyi6MPwwrxTpHLB
QcS6wpk5P8AIT71TpW6fbcZwBoHSrojeL4pNnbJx1xFICL8QKy9+8OkpJtTncVmN
tuAp9JFMPrq+Sa5Gvt+7C2/hbXzjiMjYRk0O0jtaJ47yy+I2Rnl3uQsv0vwwvmJz
4o/Pq4lJVtIAU6VNubkJWyYN7S+5NGVUyyZFOcucYpeH55BGjrtzxS2JJ2qLS9Ri
9tcEnc6O7uO2NVNcuQqT0ucJgBHYfJxBJrn80kSzclSXUp61ND22TYClhuWuxkza
vjp22TwbJs+TUJwi8SFp/IwPSP7obxgVaR06fbkkIjddoBCkBUrbWqar5MWWRuXS
K/41bhscyWYVHtEBCYSiXGe0nk8dgMDA342EGEZI1gBd7lDTIqida7zNNrd95ZiI
IYYdTKVpdK5v7AbH10dfAr9hhcaXZBR45MoJ/z93QWLvunBotKYdLTA6PVIY8m2d
pcq4B2AiupU5LdsccaYMw91LKW32Wu6VOZwS3ZHiAzqgH/D97TLZ5KRTWce9LGn0
LM0ZAc7Y0knlcEFwy750G18BIzBYGv1WuYSqkd3wbwd7PuIHRRH5fLfeTGVOJduD
p7+g2QNnN5WvxC/2MMtty5elbpsdexgS+93DmpCbqm7ep61ID9c=
=7t34
-----END PGP SIGNATURE-----

--kpvWAKCB5mXyl0PW--