Re: minor view creation weirdness - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: minor view creation weirdness
Date
Msg-id 3F7CD60E.70101@familyhealth.com.au
Whole thread Raw
In response to Re: minor view creation weirdness  (Neil Conway <neilc@samurai.com>)
Responses Re: minor view creation weirdness  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>>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




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: back from Washington, still busy
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Weird locking situation