ERROR : column c.reltriggers does not exist
От | M.R. Muthukumar |
---|---|
Тема | ERROR : column c.reltriggers does not exist |
Дата | |
Msg-id | 508968.2759.qm@web51001.mail.re2.yahoo.com обсуждение исходный текст |
Ответы |
Re: ERROR : column c.reltriggers does not exist
Re: ERROR : column c.reltriggers does not exist Re: ERROR : column c.reltriggers does not exist |
Список | 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
В списке pgsql-jdbc по дате отправления: