pg_restore fails when restoring a database view

From: "piuschan" <piuschan(at)telus(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: pg_restore fails when restoring a database view
Date: 2003-02-13 16:35:14
Message-ID: 000001c2d37d$e2742370$2d01a8c0@xpro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Gary Stainburn 2003-02-13 16:40:46 Re: Generating serial number column
Previous Message Mintoo Lall 2003-02-13 16:21:56 Generating serial number column