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

Re: Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_ch ecks" does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Lee <Chrislee(at)centurycity(dot)com(dot)hk>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_ch ecks" does not exist
Date: 2004-03-23 17:06:46
Message-ID: 21502.1080061606@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Chris Lee <Chrislee(at)centurycity(dot)com(dot)hk> writes:
> When I try to restore dump (using 7.4.2 pg_dumpall) from 7.1.2, I got the
> following error:

> [1-1] ERROR:  relation "pg_relcheck" does not exist
> [2-1] ERROR:  relation "pgadmin_checks" does not exist
> [3-1] ERROR:  relation "pgadmin_checks" does not exist
> [4-1] ERROR:  column pg_group.oid does not exist
> [5-1] ERROR:  relation "pgadmin_groups" does not exist
> [6-1] ERROR:  relation "pgadmin_groups" does not exist
> [7-1] ERROR:  column x.indislossy does not exist
> [8-1] ERROR:  relation "pgadmin_indexes" does not exist
> [9-1] ERROR:  relation "pgadmin_indexes" does not exist
> [10-1] ERROR:  column l.lancompiler does not exist
> [11-1] ERROR:  relation "pgadmin_languages" does not exist
> [12-1] ERROR:  relation "pgadmin_languages" does not exist
> [13-1] ERROR:  syntax error at or near "." at character 196
> [14-1] ERROR:  relation "pgadmin_sequences" does not exist
> [15-1] ERROR:  relation "pgadmin_sequences" does not exist
> [16-1] ERROR:  syntax error at or near "." at character 653

After further thought, what you've probably got here is a bunch of
pgadmin view definitions that are failing because they reference bits
of the system catalogs that changed between 7.1 and 7.4.  If you want
to continue to use pgadmin, you'll need to get an updated version and
install whatever views it's using now (after dropping any that did
manage to get created).

			regards, tom lane

In response to

pgsql-general by date

Next:From: Dustin SallingsDate: 2004-03-23 17:18:11
Subject: Re: linked list rewrite
Previous:From: Frank WilesDate: 2004-03-23 16:53:10
Subject: Re: linked list rewrite

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