Re: [Proposal] Global temporary tables

From: wenjing <wjzeng2012(at)gmail(dot)com>
To: Ming Li <mli(at)apache(dot)org>
Cc: wenjing <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-09-23 04:03:25
Message-ID: CA+B_3VkWyB4O-5ENB5e6QeTBsNMmUCb0u5UqRFx+ZYaFRpos_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2021年7月14日 10:56,Ming Li <mli(at)apache(dot)org> 写道:

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/.

I rewrote the case under regress to make it easier to read.
and I used the Isolation module to add some concurrent cases and fix some
bugs.

Please check code(v52) and give me feedback.

Wenjing

2) CREATE GLOBAL TEMP SEQUENCE also need to be supported
in src/bin/psql/tab-complete.c

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
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2021-09-23 04:09:17 Re: Added schema level support for publication.
Previous Message Amul Sul 2021-09-23 03:51:21 Re: [Patch] ALTER SYSTEM READ ONLY