Re: [Proposal] Global temporary tables

Wenjing Zeng <wjzeng2012@gmail.com>

From: wenjing <wjzeng2012@gmail.com>

To: Andrew Bille <andrewbille@gmail.com>

Cc: wenjing <wenjing@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, Tony Zhu <Tony.zhu@ww-it.cn>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2021-11-19T17:31:09Z

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

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

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