Postgres Pro
Downloads
Home   >   mailing lists

WARNING: column "footype" has type "unknown" - Mailing list pgsql-general

From Ed L.
Subject WARNING: column "footype" has type "unknown"
Date
Msg-id 200410271701.45632.pgsql@bluepolka.net
Whole thread Raw
Responses Re: WARNING: column "footype" has type "unknown"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On 7.4.6, is there any problem with defining one column of a view to be a
string literal?  For example ...

$ psql -c "create view fooview as select 'bar' as footype"
WARNING:  column "footype" has type "unknown"
DETAIL:  Proceeding with relation creation anyway.
CREATE VIEW

Or is this warning just noise in this case?

Ed

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Reasoning behind process instead of thread based
Next
From: Tom Lane
Date:
Subject: Re: WARNING: column "footype" has type "unknown"