nconway=# create view baz (a,b) as select 'hello', 'world'; WARNING: column "a" has type "unknown" DETAIL: Proceeding with relation creation anyway.
It's always done that, although the spelling of the notice has varied over the years.
I'd almost argue that we should change this message to an error
I agree.
Except that it would totally break backwards-compatibility? Or will 'unknown' fields in views be dumped with explicit casts?
Chris
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
