I have created a database view by :
CREATE VIEW V_EDUCATION_LEVEL ( id, description ) AS
SELECT 1, 'College or above'
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
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.
Add photos to your messages with MSN 8. Get 2 months FREE*.
pgsql-admin by date
|Next:||From: Andreas Schmitz||Date: 2003-02-15 11:51:09|
|Subject: Re: Still a bug in the VACUUM ??? !!!|
|Previous:||From: mallah||Date: 2003-02-14 20:46:10|
|Subject: Re: problem with 'DROP TABLE' ..|