Re: [Proposal] Global temporary tables

From: 曾文旌 <wenjing(dot)zwj(at)alibaba-inc(dot)com>
To: tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>
Cc: Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, "蔡松露(子嘉)" <zijia(at)taobao(dot)com>, "Cai, Le" <le(dot)cai(at)alibaba-inc(dot)com>, "萧少聪(铁庵)" <shaocong(dot)xsc(at)alibaba-inc(dot)com>
Subject: Re: [Proposal] Global temporary tables
Date: 2020-03-31 04:11:58
Message-ID: 63744C4E-C465-4C97-9809-BF3AF03472A7@alibaba-inc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 2020年3月27日 下午6:06，tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> 写道：
>
> On 3/27/20 10:55 AM, 曾文旌 wrote:
>>> Hi Wenjing,
>>> This patch(gtt_v21_pg13.patch) is not applicable on PG HEAD, I hope you have prepared the patch on top of some previous commit.
>>> Could you please rebase the patch which we can apply on HEAD ?
>> Yes, It looks like the built-in functions are in conflict with new code.
>>
> In this below scenario, pg_dump is failing -
>
> test=# CREATE database foo;
> CREATE DATABASE
> test=# \c foo
> You are now connected to database "foo" as user "tushar".
> foo=# CREATE GLOBAL TEMPORARY TABLE bar(c1 bigint, c2 bigserial) on commit PRESERVE rows;
> CREATE TABLE
> foo=# \q
>
> [tushar(at)localhost bin]$ ./pg_dump -Fp foo > /tmp/rf2
> pg_dump: error: query to get data of sequence "bar_c2_seq" returned 0 rows (expected 1)
> [tushar(at)localhost bin]$
>
>
Thanks for review
Fixed in global_temporary_table_v23-pg13.patch

Wenjing

> --
> regards,tushar
> EnterpriseDB https://www.enterprisedb.com/ <https://www.enterprisedb.com/>
> The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message 曾文旌 2020-03-31 04:16:31 Re: [Proposal] Global temporary tables
Previous Message Amit Kapila 2020-03-31 03:57:52 Re: pg_stat_statements issue with parallel maintenance (Was Re: WAL usage calculation patch)