Re: Relation "pg_relcheck" does not exist

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: jelliott(at)artcobell(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Relation "pg_relcheck" does not exist
Date: 2003-05-17 15:52:34
Message-ID: m3n0hla7ul.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeremiah Elliott <jelliott(at)artcobell(dot)com> writes:

> Ok, I upgraded from postgres 7.2 to 7.3 and now I get this error message:
>
> Relation "pg_relcheck" does not exist
>
> After about 30 seconds of research I found that the cause is that the backend
> version and psql version are not the same. What I have been unable to find
> is how to fix it. I thought I would put postgres 7.3 on a computer that
> didn't have postgres on it at all, and use psql -h to connect to the backend
> of the upgraded database
>
> this is the statement that is causing the problems (generated by phppgadmin)

You need an updated phppgadmin then--its concept of the system table
layout is out of date. 'psql' has nothing to do with it.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-05-17 16:13:04 Re: disk space usage enlarging despite vacuuming
Previous Message Doug McNaught 2003-05-17 15:50:24 Re: disk space usage enlarging despite vacuuming