Skip site navigation (1) Skip section navigation (2)

WARNING: column "footype" has type "unknown"

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: WARNING: column "footype" has type "unknown"
Date: 2004-10-27 23:01:45
Message-ID: 200410271701.45632.pgsql@bluepolka.net (view raw or flat)
Thread:
Lists: pgsql-general
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


Responses

pgsql-general by date

Next:From: Mariusz CzuładaDate: 2004-10-27 23:24:06
Subject: Creating schema copy
Previous:From: Tom LaneDate: 2004-10-27 22:59:39
Subject: Re: Reasoning behind process instead of thread based

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group