pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: piuschan <piuschan@telus.net>
To: pgsql-sql@postgresql.org
Subject: pg_restore fails when restoring a database view
Date: Thu, 13 Feb 2003 08:35:14 -0800
Message-ID: <000001c2d37d$e2742370$2d01a8c0@xpro> (raw)

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

Message-ID: <000001c2d37d$e2742370$2d01a8c0@xpro>
Permalink:  ../000001c2d37d$e2742370$2d01a8c0@xpro/
Also on:    postgresql.org/message-id/000001c2d37d$e2742370$2d01a8c0@xpro

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: piuschan@telus.net
  Subject: Re: pg_restore fails when restoring a database view
  In-Reply-To: <000001c2d37d$e2742370$2d01a8c0@xpro>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox