pgtt v2.1 is out

From: Gilles Darold <gilles(at)darold(dot)net>
To: pgsql-announce(at)postgresql(dot)org
Subject: pgtt v2.1 is out
Date: 2020-05-11 15:03:48
Message-ID: d02b00a6-7d6b-f82f-24b2-8d105c758d3b@darold.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Grenoble - May 11th, 2020

## PostgreSQL Global Temporary Tables

Description
-----------

pgtt is a PostgreSQL extension to create, manage and use Oracle-style
Global Temporary Tables and the others RDBMS.

pgtt v2.1 has been released, this is a maintenance release to complete
the work on the extension and fix some issues.

  * Prevent use of foreign keys with GTT, not that PostgreSQL do not
    allow it but just to mimic the behavior of Oracle and others RDBMS
    like DB2, SQL Server and MySQL for example.

  * Raise an error on an attempt to partition a Global Temporary Table.
    This is not supported, again not because PostgreSQL do not allow
    partition on temporary table but because others RDBMS like Oracle,
    DB2 and MySQL do not support it.

  * Add support to comments, constraints and identity columns clauses
    when creating the GTT.

For the complete list of changes, please checkout the release note
on https://github.com/darold/pgtt/blob/master/ChangeLog

===== Links & Credits =====

pgtt 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 or directly to gilles(at)darold(dot)net(dot)

Links :

* Download:  https://github.com/darold/pgtt/releases/
* Support: use GitHub report tool at https://github.com/darold/pgtt/issues
  or contact gilles(at)darold(dot)net(dot)

--------------

**About pgtt** :

Docs & Download at https://github.com/darold/pgtt/

--
Gilles Darold
http://www.darold.net/

--
Gilles Darold
http://www.darold.net/

Browse pgsql-announce by date

  From Date Subject
Next Message Yeoh Ray Mond 2020-05-12 03:53:55 SQL Data Analysis 1.3
Previous Message Christoph Berg 2020-05-11 07:53:07 Re: arm64 on apt.postgresql.org