pgtt-rsl v2.0 have been released - HexaCluster via PostgreSQL Announce

public inbox for [email protected]  
help / color / mirror / Atom feed

From: HexaCluster via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: pgtt-rsl v2.0 have been released
Date: Sun, 08 Dec 2024 18:02:00 +0000
Message-ID: <[email protected]> (raw)

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`.
- Allow to create the global temporary table into any schema.
- Allow sub-transaction generated by SAVEPOINT.

Complete list of changes is available [here](https://github.com/darold/pgtt-rsl/blob/v2.0/ChangeLog)

## Links & Credits

pgtt-rsl is an open project. Any contribution to build a better tool is
welcome. You just have to send your ideas, features requests or patches
using the GitHub tools.

**Links :**

* Documentation:  [https://github.com/darold/pgtt-rsl/](https://github.com/darold/pgtt-rsl/)
* Download:  [https://github.com/darold/pgtt-rsl/releases/](https://github.com/darold/pgtt-rsl/releases/)
* Support:  use GitHub report tool at [https://github.com/darold/pgtt-rsl/issues](https://github.com/darold/pgtt-rsl/issues)

## About pgtt

The objective of this extension it to provide the Global Temporary Table feature waiting
for an in core implementation. The main interest of this extension is to mimic the Oracle
and DB2 behavior with GTT when you can not or don't want to rewrite the application code when
migrating to PostgreSQL.

This is a project created and maintained by Gilles Darold at [HexaCluster Corp](https://hexacluster.ai).

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pgtt-rsl v2.0 have been released
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox