Re: [Proposal] Global temporary tables

Wenjing Zeng <wjzeng2012@gmail.com>

From: wenjing <wjzeng2012@gmail.com>

To: wenjing <wenjing@gmail.com>, wenjing zeng <wjzeng2012@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2021-12-21T03:04:06Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

PageAddItemExtended(): Add LP_UNUSED assertion.
- 30aaab26e521 14.0 cited
Remove temporary files after backend crash
- cd91de0d1795 14.0 cited
Fix comment in indexing.c
- 9fd2952cf492 14.0 cited
Fix failure to ignore leftover temp tables after a server crash.
- 6919b7e32947 9.3.0 cited

Attachments

0002-gtt-v63-doc.patch (application/octet-stream) patch v63-0002
0001-gtt-v63-reademe.patch (application/octet-stream) patch v63-0001
0004-gtt-v63-regress.patch (application/octet-stream) patch v63-0004
0003-gtt-v63-implementation.patch (application/octet-stream) patch v63-0003

Send an email to trigger the regress test.

wenjing zeng <wjzeng2012@gmail.com> 于2021年12月20日周一 20:42写道：

> Post GTT v63 to fixed conflicts with the latest code.
>
>
>
> Hi Andrew
>
> Have you found any new bugs recently?
>
>
>
> Wenjing
>
>
>
>
> 2021年11月20日 01:31，wenjing <wjzeng2012@gmail.com> 写道：
>
>
>
> Andrew Bille <andrewbille@gmail.com> 于2021年11月15日周一 下午6:34写道：
>
>> Thanks for the patches. The feature has become much more stable.
>> However, there is another simple case that generates an error:
>> Master with v61 patches
>>
>> CREATE GLOBAL TEMPORARY TABLE t AS SELECT 1 AS a;
>> ERROR:  could not open file "base/13560/t3_16384": No such file or
>> directory
>>
> Thank you for pointing out that this part is not reasonable enough.
> This issue has been fixed in v62.
> Looking forward to your reply.
>
>
> Wenjing
>
>
>
>> Andrew
>>
>> On Thu, Nov 11, 2021 at 3:15 PM wenjing <wjzeng2012@gmail.com> wrote:
>>
>>> Fixed a bug in function pg_gtt_attached_pid.
>>> Looking forward to your reply.
>>>
>>>
>>> Wenjing
>>>
>>>
>
>
> <0001-gtt-v62-reademe.patch><0004-gtt-v62-regress.patch>
> <0002-gtt-v62-doc.patch><0003-gtt-v62-implementation.patch>
>
>
>
>
>