From: | Tadipathri Raghu <traghu(dot)dba(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: "\d pg_class" fails in PG 8.4 |
Date: | 2010-03-25 04:37:44 |
Message-ID: | 645d9d71003242137s53bb2cf3me3fcfb0034173a0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2010-03-25 05:26:20 | Re: How to retrive List of Tables in a Database using... |
Previous Message | Tadipathri Raghu | 2010-03-25 04:34:54 | Re: How to retrive List of Tables in a Database using... |