Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > 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?
>
> Well, I think it's better than refusing views on temp tables, a
Neil Conway <[EMAIL PROTECTED]> writes:
> 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?
Well, I think it's better than refusing views on temp tables, as the
spec would have us do.
Neil Conway wrote:
> I was browsing through SQL92 and I noticed this, when discussing the
> CREATE VIEW syntax:
>
> "5) Any that is specified in the shall
> be different from the of any declaration>."
>
> ( is the defintion of the view. This basically says
> that you're not allowed to create
I was browsing through SQL92 and I noticed this, when discussing the
CREATE VIEW syntax:
"5) Any that is specified in the shall
be different from the of any ."
( is the defintion of the view. This basically says
that you're not allowed to create views on temp tables.)
Currently, PostgreSQL a
