> 2020年4月24日 下午9:03，tushar <tushar.ah...@enterprisedb.com> 写道： > > 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] The truncate GTT drop was removed. So the problem goes away.
Wenjing > postgres=!# > > -- > regards,tushar > EnterpriseDB https://www.enterprisedb.com/ > The Enterprise PostgreSQL Company
smime.p7s
Description: S/MIME cryptographic signature
