views on temp tables

I was browsing through SQL92 and I noticed this, when discussing the
CREATE VIEW syntax:

"5) Any <table name> that is specified in the <query expression> shall
be different from the <table name> of any <temporary table
declaration>."

(<query expression> is the defintion of the view. This basically says
that you're not allowed to create views on temp tables.)

Currently, PostgreSQL allows this -- when the session ends and the temp
table is dropped, an subsequent queries on the view fail. Is this the
optimal behavior?

Cheers,

Neil

-- 
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC