Hello,
when trying to use SQL developer
| Oracle IDE | 4.2.0.17.089.1709 |
with PosgreSQL 9.5
I get errors in postgresql.log like :
2017-07-30 00:26:00 CEST ERREUR: erreur de syntaxe sur ou près de « "INDEX_NAME" » au caractère 99
2017-07-30 00:26:00 CEST INSTRUCTION :
select distinct
t.relname as table_name,
i.relname as index_name "INDEX_NAME",
a.attname as column_name
from
pg_class t,
pg_class i,
pg_index ix,
pg_attribute a
where
t.oid = ix.indrelid
and i.oid = ix.indexrelid
and a.attrelid = t.oid
and a.attnum = ANY(ix.indkey)
and t.relkind = 'r'
and t.relname = $1
order by
t.relname,
i.relname
when trying to view indexes in schema browser.
I s there a fix for this syntax error ?
Thanks in advance
Regards
PAscal