Re: [Proposal] Global temporary tables

2020年3月31日 下午9:59，Prabhat Sahu <prabhat.sahu@enterprisedb.com> 写道：

Hi Wenjing,
Thanks for the new patch.
I saw with the patch(gtt_v23.patch), we are supporting the new concept "global temporary sequence"(i.e. session-specific sequence), is this intentional?

It was supported in earlier versions,

This causes the sequence built into the GTT to automatically become a "global temp sequence",

Such as create global temp table (a serial);

Like GTT, the global temp sequnce is used individually for each session.

Recently, I added the global temp sequence syntax so that it can be created independently.

The purpose of this is to enable such sequence built into the GTT to support pg_dump and pg_restore.