Re: [Proposal] Global temporary tables

2020年4月27日 下午9:48，Prabhat Sahu <prabhat.sahu@enterprisedb.com> 写道：

Thanks Wenjing, for the fix patch for previous issues.

I have verified the issues, now those fix look good to me.

But the below error message is confusing(for gtt2).

postgres=# drop table gtt1;
ERROR:  cannot drop global temp table gtt1 when other backend attached it.

postgres=# drop table gtt2;
ERROR:  cannot drop index idx2 on global temp table gtt2 when other backend attached it.

I feel the above error message shown for "DROP TABLE gtt2;" is a bit confusing(looks similar to DROP INDEX gtt2;).

If possible, can we keep the error message simple as "ERROR:  cannot drop global temp table gtt2 when other backend attached it."?

I mean, without giving extra information for the index attached to that GTT.

Fixed the error message to make the expression more accurate. In v33.