Hey all,
I'm wondering if there is anything technical preventing someone from making:
DROP TEMP TABLE tablename;
work. Implementation wise the command would fail if a temporary table of
the given name doesn't exist. Today, if a temporary table exists it will
be dropped, but if tablename is not schema-qualified and a table with the
same names exists in the search path it would be dropped.
Plus its symmetrical with CREATE [TEMP] TABLE.
David J.