Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: WARNING: column "footype" has type "unknown"
- From: "Ed L." <pgsql(at)bluepolka(dot)net>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: WARNING: column "footype" has type "unknown"
- Date: Wed, 27 Oct 2004 17:34:47 -0600
- Message-id: <200410271734.47938.pgsql@bluepolka.net> <text/plain>
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)
- Follow-Ups:
- Re: WARNING: column "footype" has type "unknown"
- From: Ed L.
- Re: WARNING: column "footype" has type "unknown"
- References:
- WARNING: column "footype" has type "unknown"
- From: Ed L.
- Re: WARNING: column "footype" has type "unknown"
- From: Tom Lane
- WARNING: column "footype" has type "unknown"
- Prev by Date: Re: WARNING: column "footype" has type "unknown"
- Next by Date: Re: WARNING: column "footype" has type "unknown"
- Previous by thread: Re: WARNING: column "footype" has type "unknown"
- Next by thread: Re: WARNING: column "footype" has type "unknown"
- Indexes: