PostgreSQL: pgtt-rsl v2.0 have been released

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

Taipei, Taiwan - November 14th, 2024

PostgreSQL Global Temporary Tables - RSL

pgtt_rsl is a PostgreSQL extension to create and manage Oracle or DB2 style Global Temporary Tables. It is based on unlogged tables, Row Security Level and views. A background worker is responsible to periodically remove obsolete rows and tables. This implementation is designed to avoid catalog bloating when creating a lot of temporary tables.

An other difference is that Oracle or DB2 Global Temporary Table can be created in any schema while it is not possible with PostgreSQL where temporary table are stored in the pg_temp namespace. This version of the extension aallow to create the global temporary table in any schema.

pgtt v2.0 has been released, this is a major release that adds the following features.

• Add support to CREATE GLOBAL TEMPORARY TABLE, CREATE GLOBAL TEMPORARY TABLE ... AS SELECT and DROP TABLE.
• Al...

Get the full details here: PostgreSQL: pgtt-rsl v2.0 have been released