Skip site navigation (1) Skip section navigation (2)

ERROR : column c.reltriggers does not exist

From: "M(dot)R(dot) Muthukumar" <m_muthukumar(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: ERROR : column c.reltriggers does not exist
Date: 2009-10-19 19:21:04
Message-ID: 508968.2759.qm@web51001.mail.re2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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



      

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2009-10-19 19:40:10
Subject: Re: ERROR : column c.reltriggers does not exist
Previous:From: Oliver JowettDate: 2009-10-16 22:57:28
Subject: Re: TimeZone related issues in org.postgresql.jdbc2.TimestampUtils

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group