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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse sfpug by date

  From Date Subject
Next Message Josh Berkus 2003-02-13 18:39:18 Re: pg_restore fails when restoring a database view
Previous Message Pius Chan 2003-02-13 17:17:41 pg_restore fails when restoring a database view