Re: "\d pg_class" fails in PG 8.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tadipathri Raghu <traghu(dot)dba(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: "\d pg_class" fails in PG 8.4
Date: 2010-03-25 04:33:09
Message-ID: 9913.1269491589@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tadipathri Raghu <traghu(dot)dba(at)gmail(dot)com> writes:
> Following is the error when i try to describe the catalog table.

> 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..

Apparently you're using an old version of psql ... but I'm curious to
know just which, because I can't duplicate that exact error display with
any release branch. Anyway, pg_class.reltriggers is gone in 8.4, but
pre-8.4 psql versions don't know that.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tadipathri Raghu 2010-03-25 04:34:54 Re: How to retrive List of Tables in a Database using...
Previous Message Yogi Yang 007 2010-03-25 04:27:15 How to retrive List of Tables in a Database using...