Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tKLbi-0089uQ-GG for pgsql-announce@arkaria.postgresql.org; Sun, 08 Dec 2024 18:02:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tKLbe-001z8h-4B for pgsql-announce@arkaria.postgresql.org; Sun, 08 Dec 2024 18:02:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tKLbd-001z7f-0P for pgsql-announce@lists.postgresql.org; Sun, 08 Dec 2024 18:02:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tKLba-001hBA-Mr for pgsql-announce@lists.postgresql.org; Sun, 08 Dec 2024 18:02:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=3hUtu990vMVfXCH10Gfbd6IYV4ZubAL9/lto6RFO2aY=; b=AsFCSweLTI1BaNDqrCI+qf8ps6 VsOwMfCB7nNdlEHLTEmJGVw9auEuTgACGCKZkcFGXqL0Pd4fTorr6Pw83s78etDz0Ge/UFf4EhbSC dInrE4DZpG9Nz9Agkee2Z33nsbxIN8owV7FPXe6zyDFsZYilmHUnFjtUHJ623rKuDTiBkBtItzwOP Zz58dxh8hXUT9XuWJucPjD6MvRLvxywc0+W8CdNQ8ynUQ0UkkQ+tJ+1kTuoDOKRrAGUR0HOGMZHM6 GAUjrQBLk53gDS8MlEYPtrwgjFo1VqU07xtpvf4jm6ypZ4H3XBMOlEDIiqFx5GBRwx5rGE9UCM8KL Mm9Y4ung==; Received: from wrigleys.postgresql.org ([217.196.149.60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tKLbZ-005GZ9-SX for pgsql-announce@lists.postgresql.org; Sun, 08 Dec 2024 18:02:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tKLbW-00Fbon-OD for pgsql-announce@lists.postgresql.org; Sun, 08 Dec 2024 18:02:03 +0000 Content-Type: multipart/mixed; boundary="===============1290825338434239641==" MIME-Version: 1.0 Subject: pgtt-rsl v2.0 have been released To: PostgreSQL Announce From: HexaCluster via PostgreSQL Announce Reply-To: gilles@hexacluster.ai Date: Sun, 08 Dec 2024 18:02:00 +0000 Message-ID: <173368092021.2556776.6347613669154852312@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: 9fc2452d003930b87634b5343aad6723649b4faae33be363033eef7457e11cfa List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1290825338434239641== Content-Type: multipart/alternative; boundary="===============3822486524164404417==" MIME-Version: 1.0 --===============3822486524164404417== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable 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 Leve= l and views. A background worker is responsible to periodically remove obso= lete rows and tables. This implementation is designed to avoid catalog bloa= ting when creating a lot of temporary tables. An other difference is that Oracle or DB2 Global Temporary Table can be cre= ated 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 a= allow to create the global temporary table in any schema. pgtt v2.0 has been released, this is a major release that adds the followin= g 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/i= ssues](https://github.com/darold/pgtt-rsl/issues) ## About pgtt The objective of this extension it to provide the Global Temporary Table fe= ature waiting for an in core implementation. The main interest of this extension is to mi= mic the Oracle and DB2 behavior with GTT when you can not or don't want to rewrite the app= lication code when migrating to PostgreSQL. This is a project created and maintained by Gilles Darold at [HexaCluster C= orp](https://hexacluster.ai). --===============3822486524164404417== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable pgtt-rsl v2.0 have been released
 

pgtt-rsl v2.0 have been released

Taipei, Taiwan - November 14th, 2024

PostgreSQL Global Temporary Tab= les - RSL

pgtt_rsl is a PostgreSQL extension to creat= e and manage Oracle or DB2 style Global Temporary Tables. It is based on un= logged tables, Row Security Level and views. A background worker is respons= ible to periodically remove obsolete rows and tables. This implementation i= s designed to avoid catalog bloating when creating a lot of temporary table= s.

An other difference is that Oracle or DB2 G= lobal 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 majo= r release that adds the following features.

  • Add support to = CREATE GLOBAL TEMPORARY TABLE, CREATE GLOBAL TEMPORARY T= ABLE ... AS SELECT and DROP TABLE.
  • Allow to create= the global temporary table into any schema.
  • Allow sub-trans= action generated by SAVEPOINT.

Complete list of changes is available here

Links & Credits

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

Links :

About pgtt

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

This is a project created and maintained by= Gilles Darold at HexaCluster Corp.
This email was sent to you from HexaCluster. It was delivered on their beha= lf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to HexaCluster.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============3822486524164404417==-- --===============1290825338434239641==--