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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
