pg_restore fails when restoring a database view

Поиск
Список
Период
Сортировка
От piuschan
Тема pg_restore fails when restoring a database view
Дата
Msg-id 000001c2d37d$e2742370$2d01a8c0@xpro
обсуждение исходный текст
Список pgsql-sql

Hi,

 

I have created a database view by :

 

CREATE VIEW V_EDUCATION_LEVEL ( id, description ) AS

SELECT 1, 'College or above'

UNION ALL

SELECT 2, 'Secondary';

 

I pg_dump(ed) the database  by specifying a tar format and tried to pg_restore to a destination database. However, I encountered the following error:

 

pg_restore: creating VIEW v_education_level

pg_restore: [archiver (db)] could not execute query: ERROR:  CREATE TABLE: attribute "?column?" duplicated

pg_restore: *** aborted because of error

 

Any idea?

 

Thanks,

 

Pius

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