pgtt v2.1 is out - Mailing list pgsql-announce

From Gilles Darold
Subject pgtt v2.1 is out
Date
Msg-id d02b00a6-7d6b-f82f-24b2-8d105c758d3b@darold.net
Whole thread Raw
List 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@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/




pgsql-announce by date:

Previous
From: David Fetter
Date:
Subject: == PostgreSQL Weekly News - May 10, 2020 ==
Next
From: Yeoh Ray Mond
Date:
Subject: SQL Data Analysis 1.3