PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not exist

Поиск
Список
Период
Сортировка
От k_b0000@yahoo.se
Тема PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not exist
Дата
Msg-id alpine.LFD.2.00.0910201914280.15032@isteren.oneview.se
обсуждение исходный текст
Ответы Re: PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not exist  ("Plugge, Joe R." <JRPlugge@west.com>)
Re: PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi.

We use PostgreSQL 8.4.1 on linux.
In one of the databases we use we see the following problem.


database=# \d table001
ERROR:  column "reltriggers" does not exist
LINE 1: SELECT relhasindex, relkind, relchecks, reltriggers, relhasr...
                                                 ^


As i understand from from seaching the archives reltriggers was changed in
8.4, what i do not understand is what to do about it.

Is there a fix or SQL i can apply or run to fix this issue, or would it be
possible to dump all data and re-import it?

Any suggestion on what can be done?


Thanks!

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Tena Sakai"
Дата:
Сообщение: can I get a bit more attribute out of \dt directive?
Следующее
От: "Plugge, Joe R."
Дата:
Сообщение: Re: PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not exist