Re: minor view creation weirdness

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> >> I'd almost argue that we should change this message to an error
>
> > I agree.
>
> Motion proposed and seconded; any objections out there?

Uhm, doesn't the spec have anything to say about this?
I mean, the view sure looks like standard SQL on its face.

In any case, I would sure think there was something strange about a query
working fine as a select but not working in a view:

slo=> select 'foo' as a,'bar' as b;
a | b
-----+-----
foo | bar
(1 row)

slo=> create view x as select 'foo' as a,'bar' as b;
WARNING: Attribute "a" has an unknown type
Proceeding with relation creation anyway
WARNING: Attribute "b" has an unknown type
Proceeding with relation creation anyway
CREATE VIEW

slo=> select * from x;
a | b
-----+-----
foo | bar
(1 row)

--
greg