> 2020年4月20日 下午9:15,tushar <tushar.ahuja@enterprisedb.com> 写道:
>
> 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
of8192 bytes
Fixed in global_temporary_table_v29-pg13.patch
Please check.
Wenjing
>
> --
> regards,tushar
> EnterpriseDB https://www.enterprisedb.com/
> The Enterprise PostgreSQL Company