Обсуждение: pg_restore fails when restoring a database view

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