It seems that you cannot create a temporary table in a database other than "temp". In other words, the following is an error:
% CREATE TEMP TABLE temp_db.temp_table ... temporary table name must be unqualified But this is not: % CREATE TEMP TABLE temp.temp_table ... Neither is this: % CREATE TABLE temp_db.temp_table ... In this last case, is the table being created as a temporary table? Or is it a regular table? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
