423,822 Members | 1,356 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,822 IT Pros & Developers. It's quick & easy.

WARNING: column "footype" has type "unknown"

P: n/a

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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Ed L." <pg***@bluepolka.net> writes:
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?


Depending on what you expect to do with the view, you'd probably be
better off casting the literal to some specific type, perhaps text
or varchar. An example of what you won't be able to do:

regression=# select distinct * from fooview;
ERROR: failed to find conversion function from "unknown" to text

I think there was some discussion in the past of forcing the view column
to text type, but evidently nothing's been done about it yet.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #2

P: n/a
On Wednesday October 27 2004 5:24, Tom Lane wrote:
An example of what you won't be able to do:

regression=# select distinct * from fooview;
ERROR: failed to find conversion function from "unknown" to text


Is that 8.0 you're working against there? Here's my 7.4.6 installation:

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

$ psql -c "select * from fooview"
footype
---------
bar
(1 row)

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #3

P: n/a
On Wednesday October 27 2004 5:34, Ed L. wrote:
On Wednesday October 27 2004 5:24, Tom Lane wrote:
An example of what you won't be able to do:

regression=# select distinct * from fooview;
ERROR: failed to find conversion function from "unknown" to text


Is that 8.0 you're working against there? Here's my 7.4.6 installation:

$ psql -c "select * from fooview"


Ah, sorry. Just noticed the "distinct". Thanks.

Ed
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.