On 4/22/20 2:49 PM, 曾文旌 wrote:
I provide the TRUNCATE tablename DROP to clear the data in the GTT and
delete the storage files.
This feature requires the current transaction to commit immediately
after it finishes truncate.
Thanks Wenjing , Please refer this scenario
postgres=# create global temp table testing (a int);
CREATE TABLE
postgres=# begin;
BEGIN
postgres=*# truncate testing; -- working [1]
TRUNCATE TABLE
postgres=*# truncate testing drop;
ERROR: Truncate global temporary table cannot run inside a transaction
block --that is throwing an error claiming something which i did
successfully [1]
postgres=!#
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
