>Fixed in global_temporary_table_v29-pg13.patch >Please check. I find this is the most latest mail with an attachment, so I test and reply on this thread, several points as below:
1. I notice it produces new relfilenode when new session login and some data insert. But the relfilenode column in pg_class still the one when create the global temp table. I think you can try to show 0 in this area as what nail relation does. 2. The nail relations handle their relfilenodes by RelMapFile struct, and this patch use hash entry and relfilenode_list, maybe RelMapFile approach more understandable in my opinion. Sorry if I miss the real design for that. 3. I get a wrong result of pg_relation_filepath() function for global temp table, I think it's necessaryto keep this an correct output. 4. In gtt_search_by_relid() function, it has not handle the missing_ok argument if gtt_storage_local_hash is null. There should be some comments if it's the right code. 5. It's a long patch and hard to review, I think it will pretty good if it can be divided into several subpatches with relatively independent subfunctions. Regards, Highgo Software (Canada/China/Pakistan) URL : www.highgo.ca EMAIL: mailto:movead(dot)li(at)highgo(dot)ca