Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

syntax error "INDEX_NAME" when viewing indexes in schema browser with PostgreSQL

legrand_legrand-JavaNetJul 30 2017 — edited Aug 1 2017

Hello,

when trying to use SQL developer

Oracle IDE4.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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2017
Added on Jul 30 2017
1 comment
376 views