"Merlin Moncure" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
