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