Re: [Proposal] Global temporary tables

2020-03-25 Thread wjzeng
> 2020年3月25日 下午6:44,tushar 写道: > > On 3/17/20 9:15 AM, 曾文旌(义从) wrote: >> reindex GTT is already supported >> >> Please check global_temporary_table_v20-pg13.patch >> > Please refer this scenario - > > > postgres=# create global temp table co(n int) ; > CREATE TABLE > > postgres=# create

Re: [Proposal] Global temporary tables

2020-03-25 Thread wjzeng
> 2020年3月25日 下午10:16,tushar 写道: > > On 3/17/20 9:15 AM, 曾文旌(义从) wrote: >> Please check global_temporary_table_v20-pg13.patch > > There is a typo in the error message > > postgres=# create global temp table test(a int ) > with(on_commit_delete_rows=true) on commit delete rows; > ERROR: can

Re: [Proposal] Global temporary tables

2020-03-25 Thread wjzeng
> 2020年3月25日 下午8:52,Prabhat Sahu 写道: > > Hi All, > > Please check the behavior of GTT having column with "SERIAL" datatype and > column with default value as "SEQUENCE" as below: > > Session1: > postgres=# create sequence gtt_c3_seq; > CREATE SEQUENCE > postgres=# create global temporary