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

Re: type unknown?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: type unknown?
Date: 2008-09-18 21:01:33
Message-ID: 2235.1221771693@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: Randall WilsonDate: 2008-09-18 21:49:40
Subject: Re: Idle Error invalid byte sequence
Previous:From: Tom LaneDate: 2008-09-18 20:57:30
Subject: Re: Idle Error invalid byte sequence

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