Re: "\d pg_class" fails in PG 8.4 - Mailing list pgsql-general

From Tadipathri Raghu
Subject Re: "\d pg_class" fails in PG 8.4
Date
Msg-id 645d9d71003242137s53bb2cf3me3fcfb0034173a0@mail.gmail.com
Whole thread Raw
In response to Re: "\d pg_class" fails in PG 8.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi Tom,
 
As you are best always on this Community Fourm. Thanks for your help. It got resolved.
 
Regards
Raghavendra

On Thu, Mar 25, 2010 at 10:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Tadipathri Raghu <traghu.dba@gmail.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

pgsql-general by date:

Previous
From: Tadipathri Raghu
Date:
Subject: Re: How to retrive List of Tables in a Database using...
Next
From: John R Pierce
Date:
Subject: Re: How to retrive List of Tables in a Database using...