Neil Conway <[EMAIL PROTECTED]> writes: > Is this a bug? > 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. These days we tend to force "unknown" to become "text" if a specific data type is really required, and I suppose a case could be made that CREATE VIEW should do that too. But the consequences of guessing wrong are probably worse here than elsewhere, since you can't really change the view column type short of dropping and recreating the view. I'd almost argue that we should change this message to an error: ERROR: column "a" has type "unknown" HINT: Explicitly cast the string literal to some specific type. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])