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/
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 |