Relation "pg_relcheck" does not exist
От | Jeremiah Elliott |
---|---|
Тема | Relation "pg_relcheck" does not exist |
Дата | |
Msg-id | 200305131530.20136.jelliott@artcobell.com обсуждение исходный текст |
Ответы |
Re: Relation "pg_relcheck" does not exist
|
Список | 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
В списке pgsql-general по дате отправления: