Author Topic: Confirm that EA 16 is NOT buggy for PostgreSQL reverse engineering?  (Read 4474 times)

Richard Freggi

  • EA User
  • **
  • Posts: 390
  • Karma: +14/-7
    • View Profile
I held off upgrading from my version 1310 because I wanted to avoid the trap of "where did my menu go?" and did not see much benefit overall.  But I'm very eager to upgrade to EA 16 with SQLite repository.

However I just found out that my 1310 has a bug for "Import schema from ODBC" for PostgreSQL (I'm reverse engineering from v. 12.02).  The trace log shows ERROR(ERROR) 42702 'column reference "oid" is ambiguous' at this stage: 

Code: [Select]
[53.579]PQsendQuery: 09C69420 'BEGIN;declare "SQL_CUR09FBCC88" cursor with hold for SELECT
    n.nspname                                       AS ObjectSchema,    --1
    c.relname                                       AS ObjectName,      --2
    CASE
WHEN c.relkind = 'r' THEN 'TABLE'
        WHEN c.relkind = 'v' THEN 'VIEW'
        WHEN c.relkind = 'S' THEN 'SEQUENCE'
    END                                             AS ObjectType,     --3
    COALESCE(OBJ_DESCRIPTION(c.oid),'')             AS Remarks,     --4
    COALESCE('TABLESPACE=' || t.spcname || ';','')  AS Properties     --5
FROM
    (SELECT *, oid
    FROM pg_class
    WHERE relkind IN ('r','v')
    ) c   
INNER JOIN 
    (SELECT *, oid
    FROM    pg_namespace
    WHERE nspname IN ('schema_names') --WHERE   nspname NOT IN ('other_schema_names')
    ) n
    ON  c.relnamespace = n.oid
LEFT JOIN   
    pg_tablespace t
ON 
    c.reltablespace = t.oid
Order By n.nspname, c.relkind, c.relname;fetch 100 in "SQL_CUR09FBCC88"'
[53.822] ok: - 'C' - BEGIN
[53.822] ERROR(ERROR) 42702 'column reference "oid" is ambiguous'
[53.823]PQsendQuery: 09C69420 'ROLLBACK'

I don't have access to EA16 since my registration expired: can anyone confirm if EA16 has no issues reverse engineering from PostgreSQL?  Thanks!!!!

Richard Freggi

  • EA User
  • **
  • Posts: 390
  • Karma: +14/-7
    • View Profile
Answering my own question.  No problem with PostgreSQL and EA 16, I used the 64 bit driver in my computer (incompatible with EA 32 bit) and it worked fine.