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 по дате отправления: