Re: ERROR : column c.reltriggers does not exist

I'm showing in PostgreSQL 8.3.3 has the field reltriggers, but in 8.4.0 the
field no longer exists and looks like may have been replaced with
relhastriggers,
which is boolean? Try:

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.relhastriggers = 'f') 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

danap
http://dandymadeproductions.com

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