"\d pg_class" fails in PG 8.4

Поиск
Список
Период
Сортировка
От Tadipathri Raghu
Тема "\d pg_class" fails in PG 8.4
Дата
Msg-id 645d9d71003242122h1252c5fbqbeed58e9c4ba64c0@mail.gmail.com
обсуждение исходный текст
Ответы Re: "\d pg_class" fails in PG 8.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi All,
 
Following is the error when i try to describe the catalog table.
 
Version Info
========
postgres=# select version();
                                                      version
-------------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.4.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20070626 (Red Hat 4.1.2-14), 64-bit
(1 row)
Error
===
postgres=# \d pg_class
ERROR:  column "reltriggers" does not exist at character 41
STATEMENT:  SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules,
        relhasoids , reltablespace
        FROM pg_catalog.pg_class WHERE oid = '1259'
ERROR:  column "reltriggers" does not exist at character 41
LINE 1: SELECT relhasindex, relkind, relchecks, reltriggers, relhasr...
Could you please guide me in this, and what is the cause for it..
 
Regards
Raghavendra
 

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

Предыдущее
От: william wayne
Дата:
Сообщение: boualem guechtouli
Следующее
От: Yogi Yang 007
Дата:
Сообщение: How to retrive List of Tables in a Database using...