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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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