CREATE TEMP TABLE t1 ON COMMIT AS SELECT TRUE::BOOL LIMIT 0;

In a follow up to my post from two days ago about creating TEMP TABLES,
I noticed what I think is kind of a glaring omission: CREATE TEMP TABLE
AS doesn't support ON COMMIT.  Nothing Earth shattering, but it did
catch me by surprise.  There's also no ALTER TABLE statement that I can
issue to tweak a TEMP table to have it include ON COMMIT behavior after
its been created.  If this isn't low hanging fruit, can someone add it
to the TODO list?  -sc


-- This works
CREATE TEMP TABLE t1 AS SELECT TRUE::BOOL LIMIT 0;

-- This does not
CREATE TEMP TABLE t1 ON COMMIT DROP AS SELECT TRUE::BOOL LIMIT 0;

--
Sean Chittenden