Skip to content

v0.0.6

Choose a tag to compare

@Levyks Levyks released this 02 Sep 18:57
· 81 commits to main since this release

IDE schema browser: fill out the ALL_* data dictionary

DataGrip / IntelliJ (and SQL Developer, DBeaver) introspect a long tail of
Oracle dictionary views and abort on the first missing view or column. This
release widens the ones they read column-by-column and stubs the rest.

  • ALL_TABLES / ALL_INDEXES / ALL_TRIGGERS (and their USER_* views)
    grow the full Oracle column set, appended so CREATE OR REPLACE VIEW accepts
    it. ALL_TRIGGERS now derives real timing / event / BEFORE_ROW etc. from
    pg_trigger.tgtype and carries ACTION_TYPE.
  • New: SYS.ALL_OBJECT_TABLES, ALL_MVIEW_LOGS, ALL_MVIEW_COMMENTS,
    ALL_IND_EXPRESSIONS.
  • ~45 new SYS.* stub views — partitioning / subpartitions, object types /
    collections / methods, LOBs, ALL_TAB_IDENTITY_COLS (real, from
    pg_attribute.attidentity), privileges, tablespaces / segments, scheduler /
    jobs / queues, directories / libraries / java / clusters / operators /
    indextypes, XML DB, editions, VPD policies, dimensions, optimizer stats &
    histograms, PL/SQL settings, identifiers. Empty (no PostgreSQL equivalent) —
    the point is only that a SELECT resolves instead of ORA-00942 / ORA-00904.
  • Version / identity: SYS.PRODUCT_COMPONENT_VERSION,
    NLS_DATABASE_PARAMETERS, DATABASE_PROPERTIES, GLOBAL_NAME — plus
    unqualified copies of the first three.

Known gap: SYS.ALL_SOURCE resolves but returns nothing.

docker pull levyks/pgsaci:0.0.6 — digest sha256:5108c80e80d8…, 9.77 MB.