Re: [Proposal] Global temporary tables

On 4/20/20 2:59 PM, 曾文旌 wrote:
> Please check my new patch.

Thanks Wenjing. Please refer this below scenario , getting error - 
ERROR:  could not read block 0 in file "base/16466/t4_16472": read only
0 of 8192 bytes

Steps to reproduce

Connect to psql terminal,create a table ( create global temp table t2 (n
int primary key ) on commit delete rows;)
exit from psql terminal and execute (./clusterdb -t t2 -d postgres -v)
connect to psql terminal and one by one execute these below sql statements
(
cluster verbose t2 using t2_pkey;
cluster verbose t2 ;
alter table t2 add column i int;
cluster verbose t2 ;
cluster verbose t2 using t2_pkey;
create unique index ind on t2(n);
create unique index concurrently  ind1 on t2(n);
select * from t2;
)
This last SQL - will throw this error -  - ERROR:  could not read block
0 in file "base/16466/t4_16472": read only 0 of 8192 bytes

--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company