Re: [Proposal] Global temporary tables

From: wenjing <wjzeng2012(at)gmail(dot)com>
To: Ming Li <mli(at)apache(dot)org>
Cc: wenjing(at)gmail(dot)com, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, shawn wang <shawn(dot)wang(dot)pg(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, 曾文旌 <wenjing(dot)zwj(at)alibaba-inc(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com>, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [Proposal] Global temporary tables
Date: 2021-07-22 09:40:49
Message-ID: CA+B_3V=vnqXetHT2NnYGVuUmyKM1+vGdbMA43dZ34ja9V8WJ2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ming Li <mli(at)apache(dot)org> 于2021年7月14日周三 上午10:56写道:

> Hi Wenjing,
>
> Some suggestions may help:
>
> 1) It seems that no test case covers the below scenario: 2 sessions attach
> the same gtt, and insert/update/select concurrently. It is better to use
> the test framework in src/test/isolation like the code changes in
> https://commitfest.postgresql.org/24/2233/.
>

Thanks for pointing this out, I am working on this issue.

>
> 2) CREATE GLOBAL TEMP SEQUENCE also need to be supported
> in src/bin/psql/tab-complete.c
>
It has been fixed in V51, please check

Regards,
wenjing

>
>
> On Wed, Jul 14, 2021 at 10:36 AM wenjing <wjzeng2012(at)gmail(dot)com> wrote:
>
>> Rebase code based on the latest version.
>>
>> Regards,
>> wenjing
>>
>>

Attachment Content-Type Size
0002-gtt-v51-regress.patch application/octet-stream 48.9 KB
0003-gtt-v51-doc.patch application/octet-stream 7.5 KB
0001-gtt-v51.patch application/octet-stream 171.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Pryzby 2021-07-22 09:41:54 Re: alter table set TABLE ACCESS METHOD
Previous Message Pavel Stehule 2021-07-22 09:28:49 Re: psql - add SHOW_ALL_RESULTS option