Relation "pg_relcheck" does not exist

On Tue, 13 May 2003, Jeremiah Elliott wrote:

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?

The above query isn't valid on a 7.3 or newer server, pg_relcheck was
incorporated into pg_constraint AFAIR. There might be a newer version of
phppgadmin that will give you a 7.3 legal query.