From: | 曾文旌 <wenjing(dot)zwj(at)alibaba-inc(dot)com> |
---|---|
To: | tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> |
Cc: | Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, "蔡松露(子嘉)" <zijia(at)taobao(dot)com>, "Cai, Le" <le(dot)cai(at)alibaba-inc(dot)com> |
Subject: | Re: [Proposal] Global temporary tables |
Date: | 2020-04-21 06:19:24 |
Message-ID: | A58F9CA1-1C93-414E-8A9F-4110521ACEA6@alibaba-inc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 2020年4月20日 下午9:15,tushar <tushar(dot)ahuja(at)enterprisedb(dot)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 of 8192 bytes
Fixed in global_temporary_table_v29-pg13.patch
Please check.
Wenjing
Attachment | Content-Type | Size |
---|---|---|
global_temporary_table_v29-pg13.patch | application/octet-stream | 206.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2020-04-21 06:29:54 | Re: Remove non-fast promotion Re: Should we remove a fallback promotion? take 2 |
Previous Message | Kyotaro Horiguchi | 2020-04-21 06:08:30 | forgotten initalization of a variable |