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

pg_restore fails when restoring a database view

From: "Pius Chan" <chanpius(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_restore fails when restoring a database view
Date: 2003-02-14 21:16:16
Message-ID: F116ccOQZVIcLc4Tq1o00001718@hotmail.com (view raw or flat)
Thread:
Lists: 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


Responses

pgsql-admin by date

Next:From: Andreas SchmitzDate: 2003-02-15 11:51:09
Subject: Re: Still a bug in the VACUUM ??? !!!
Previous:From: mallahDate: 2003-02-14 20:46:10
Subject: Re: problem with 'DROP TABLE' ..

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