"\d pg_class" fails in PG 8.4

From: Tadipathri Raghu <traghu(dot)dba(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: "\d pg_class" fails in PG 8.4
Date: 2010-03-25 04:22:32
Message-ID: 645d9d71003242122h1252c5fbqbeed58e9c4ba64c0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yogi Yang 007 2010-03-25 04:27:15 How to retrive List of Tables in a Database using...
Previous Message william wayne 2010-03-25 01:12:34 boualem guechtouli