Re: observations about temporary tables and schemas

"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> writes:
> ... In this case, I think the
> SQL spec was not thought out very well.

Many people think that about a lot of aspects of the spec ;-)

> I did not see a TODO item regarding global temporary tables...has this
> been attempted/done?

We concluded in the last discussion of this subject that our existing
temp table behavior actually approaches the spec's GLOBAL TEMP behavior
more nearly than it does LOCAL TEMP; but in any case, without modules
the difference is moot. Accordingly, 7.4 will accept either syntax,
and there is no more TODO. See the archives from a few months back, or
http://developer.postgresql.org/docs/postgres/sql-createtable.html#SQL-CREATETABLE-COMPATIBILITY
which distills that discussion.

regards, tom lane