Hello if I understand well, there isn't any difference between local and global temp tables in postgresql.
I have question. Is correct implementation of global temp in Oracle or Firebird, where content of glob.temp table is session visible and metadata of g.t.t is persistent? Standard is unclean and speak more about local temp tables. "The materialization of a temporary table does not persist beyond the end of the SQL-session in which the table was materialized. Temporary tables are effectively empty at the start of an SQL-session.' -- It means so temp table exists on the start of session. What is your opinion about implementation this feature into postgresql (persistent temp tables)? Regards Pavel Stehule ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend