Relation "pg_relcheck" does not exist

From: Jeremiah Elliott <jelliott(at)artcobell(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Relation "pg_relcheck" does not exist
Date: 2003-05-13 20:11:17
Message-ID: 200305131511.17792.jelliott@artcobell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)
SELECT
rcname as index_name,
rcsrc
FROM
pg_relcheck,
pg_class bc
WHERE
rcrelid = bc.oid
and bc.relname = 'appsettings'
and not exists
(select * from pg_relcheck as c, pg_inherits as i
where i.inhrelid = pg_relcheck.rcrelid
and c.rcname = pg_relcheck.rcname
and c.rcsrc = pg_relcheck.rcsrc
and c.rcrelid = i.inhparent)

when I do psql -V from on the database server it shows that I am running
7.3.2, which is the same as the backend version.
Any clues as to how I would fix this?
thanks
postgres was built with gcc 2.95. the running kernel is 2.4.20
-Jeremiah

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Manfred Koizar 2003-05-13 20:28:42 Re: Serialization, Locking...implement processing Queue with a table
Previous Message DeJuan Jackson 2003-05-13 19:44:31 Re: Querying the last value of all sequences