type unknown?

Поиск
Список
Период
Сортировка
От Carol Walter
Тема type unknown?
Дата
Msg-id ECE4FB45-9CD3-429F-9743-1BDA1D771942@indiana.edu
обсуждение исходный текст
Ответы Re: type unknown?
Список pgsql-admin
Greetings one and all,

I am porting all my databases from a 32 bit Postgres engine to 64 bit
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.

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;

There are a number of views in this particular database where
"collection" is used in this way and they all get this warning.  Text
is a valid type, albeit nonstandard.  What is triggering this warning?

Thanks,
Carol


В списке pgsql-admin по дате отправления:

Предыдущее
От: Randall Wilson
Дата:
Сообщение: Re: Idle Error invalid byte sequence
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Idle Error invalid byte sequence