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

Re: pg_restore fails when restoring a database view

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Pius Chan" <chanpius(at)hotmail(dot)com>, sfpug(at)postgresql(dot)org
Subject: Re: pg_restore fails when restoring a database view
Date: 2003-02-13 18:18:43
Message-ID: web-2838258@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: sfpug
Hi, Pius!

Are you in the San Francisco Bay Area?   Please tell us a little about
yourself.

> 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

What version of Postgres are you restoring to?  The view syntax you
used was not supported in version 7.1.x, so if you're trying to
"downgrade", you'd encounter the above problem.

-Josh

In response to

sfpug by date

Next:From: Josh BerkusDate: 2003-02-13 18:39:18
Subject: Re: pg_restore fails when restoring a database view
Previous:From: Pius ChanDate: 2003-02-13 17:17:41
Subject: pg_restore fails when restoring a database view

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