Re: ERROR : column c.reltriggers does not exist

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(at)yahoo(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>