Re: ERROR : column c.reltriggers does not exist - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: ERROR : column c.reltriggers does not exist
Date
Msg-id 491f66a50910191240s60f26112na10026b31970bbe4@mail.gmail.com
Whole thread Raw
In response to ERROR : column c.reltriggers does not exist  ("M.R. Muthukumar" <m_muthukumar@yahoo.com>)
List pgsql-jdbc
This is likely dbvisualizer executing the statement below. I don't believe the driver executes that internally.

Dave

On Mon, Oct 19, 2009 at 3:21 PM, M.R. Muthukumar <m_muthukumar@yahoo.com> wrote:
I am using dbvisualizer with postgresql-8.4-701.jdbc3.jar, postgres server version is 8.4.1
When I try to get the table definition I am getting the following error :

ERROR: column c.reltriggers does not exist
Position: 414

Details are :

The command that caused the problem:
SELECT c.relname                                     AS "Name",
      n.nspname                                     AS "Schema",
      pg_get_userbyid(c.relowner)                   AS "Owner",
      t.spcname                                     AS "Tablespace",
      c.relhasindex                                 AS "Has Indexes",
      c.relhasrules                                 AS "Has Rules",
      (c.reltriggers > 0)                           AS "Has Triggers",
      c.relisshared                                 AS "Is Shared",
      c.relnatts                                    AS "N Cols",
      pg_catalog.obj_description(c.oid, 'pg_class') AS "Comment"
FROM pg_class c
  LEFT JOIN pg_namespace n   ON n.oid = c.relnamespace
  LEFT JOIN pg_tablespace t  ON t.oid = c.reltablespace
WHERE c.relkind = 'r'::"char"
AND   n.nspname LIKE 'public'
AND   c.relname LIKE '%'
ORDER BY n.nspname, c.relname

I am thinking reltriggers column is no longer in pg_class in 8.4.1 version. Is there a updated
JDBC driver for 8.4.x.

Any help is greatly appreciated.

Thanks a bunch.

-Muthu





--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

pgsql-jdbc by date:

Previous
From: "M.R. Muthukumar"
Date:
Subject: ERROR : column c.reltriggers does not exist
Next
From: dmp
Date:
Subject: Re: ERROR : column c.reltriggers does not exist