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:30:20 |
Message-ID: | 200305131530.20136.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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-05-13 20:57:24 | Re: Relation "pg_relcheck" does not exist |
Previous Message | Manfred Koizar | 2003-05-13 20:28:42 | Re: Serialization, Locking...implement processing Queue with a table |