BUG #2326: Problems Upgrading from 8.0.2

From: "Dan B(dot)" <thedanburke(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2326: Problems Upgrading from 8.0.2
Date: 2006-03-16 16:00:20
Message-ID: 200603161600.k2GG0KF5085491@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2326
Logged by: Dan B.
Email address: thedanburke(at)hotmail(dot)com
PostgreSQL version: 8.1.3
Operating system: Mac OS X 10.4.1
Description: Problems Upgrading from 8.0.2
Details:

I'm trying to restore a database dumpall from postgres 8.0.2 to an 8.1.3
installation on the same machine but have encountered an error which has
resulted in some views not being recreated.

the problem is with the following statement in the dump file:

"CREATE VIEW wamp_product_extdesc AS
SELECT contenttranslation.franchise_code,
contenttranslation.contentobject_id,
"language".code AS language_code,
"language".uid AS language_id,
contenttranslation.info,
contenttranslation.graphic_url,
contenttranslation.contenttype_id,
contenttype.info AS contenttype_code
FROM contenttranslation, "language" contenttype
WHERE (("language".uid = contenttranslation.language_id) AND
(contenttype.uid = contenttranslation.contenttype_id));"

Which results in:
" psql:backuptoday.bak:5182: ERROR: missing FROM-clause entry for table
"language" "

Any help would be appreciated,
Dan

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Hollins 2006-03-16 22:16:30 BUG #2327: Startup script for FC4 with selinux
Previous Message Riccardo 2006-03-16 15:05:48 BUG #2325: fails to compile with undefined symbol (FP_PLUS_INF)