Re: type unknown?

Well, it''s a guess. A "CREATE VIEW" follows the line that specifies
the warning. (An "ALTER TABLE" immediately precedes it.) This made
me think that is was on a view; then I went through the views till I
found one with a column called "collection". Is there another way I
can isolate what's happening?

Carol

On Sep 18, 2008, at 5:01 PM, Tom Lane wrote:

> Carol Walter <walterc(at)indiana(dot)edu> writes:
>> Postgres. To do this, I did a pg_dumpall and I'm restoring. I got
>> an error on the restoration as follows:
>
>> psql:/dbsdisk/data_load/dbdev_all_080915.sql:3920581: WARNING:
>> column "collection" has type "unknown"
>> DETAIL: Proceeding with relation creation anyway.
>
> AFAIK the only way to get that warning is with an undecorated literal
> constant:
>
> regression=# create view foo as select 'bar' as collection;
> WARNING: column "collection" has type "unknown"
> DETAIL: Proceeding with relation creation anyway.
> CREATE VIEW
> regression=# \d foo
> View "public.foo"
> Column | Type | Modifiers
> ------------+---------+-----------
> collection | unknown |
> View definition:
> SELECT 'bar' AS collection;
>
> ... which is not what you're showing here:
>
>> The view that was being processes when the error occurred is:
>
>> View "public.v_cos_master_year_count"
>> Column | Type | Modifiers
>> -------------+-------------------+-----------
>> collection | text |
>> year | character varying |
>> entry_count | bigint |
>> View definition:
>> SELECT 'cos'::text AS collection, cos_master.year_published AS
>> "year", count(cos_master.id) AS entry_count
>> FROM cos_master
>> GROUP BY cos_master.year_published, cos_master.collection
>> ORDER BY cos_master.year_published;
>
> Are you sure you correctly identified which view is drawing the
> warning?
>
> regards, tom lane