Re: Global temporary tables

Dean Rasheed <dean.a.rasheed@gmail.com>

View thread View on postgr.es

From: Dean Rasheed <dean.a.rasheed@gmail.com>

To: Pavel Stehule <pavel.stehule@gmail.com>

Cc: Andrew Dunstan <andrew@dunslane.net>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2026-06-23T09:12:43Z

Lists: pgsql-hackers

Attachments

v3-0001-Basic-support-for-global-temporary-tables.patch (text/x-patch) patch v3-0001
v3-0002-Support-indexes-on-global-temporary-tables.patch (text/x-patch) patch v3-0002
v3-0003-Support-global-temporary-sequences.patch (text/x-patch) patch v3-0003
v3-0004-Support-global-temporary-catalog-tables-and-add-p.patch (text/x-patch) patch v3-0004
v3-0005-Add-relation-statistics-columns-to-pg_temp_class.patch (text/x-patch) patch v3-0005
v3-0006-Add-relfrozenxid-and-relminmxid-columns-to-pg_tem.patch (text/x-patch) patch v3-0006
v3-0007-Add-pg_temp_statistic-global-temporary-catalog-ta.patch (text/x-patch) patch v3-0007
v3-0008-Add-pg_temp_statistic_ext_data-global-temporary-c.patch (text/x-patch) patch v3-0008
v3-0009-Add-pg_temp_index-global-temporary-catalog-table.patch (text/x-patch) patch v3-0009

v3 attached, attempting to fix another issue reported by the cfbot --
need to tolerate relation_open() on a global temporary relation, when
in parallel mode because pg_get_viewdef() does that.

Regards,
Dean

Commits

doc: clarify MERGE PARTITIONS adjacency requirement
- 57f19774d6c8 master cited