pg_restore fails when restoring a database view - Mailing list pgsql-admin

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';

Then 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

I am running Postgres 7.2.2.

Thanks,

Pius






_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail