Thread: pgtt v2.1 is out

pgtt v2.1 is out

From
Gilles Darold
Date:
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@darold.net.

Links :

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

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

**About pgtt** :

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

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

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