Skip to content

v0.0.4

Choose a tag to compare

@Levyks Levyks released this 01 Sep 04:38
· 83 commits to main since this release

IDE schema browser: objects appear under the connected user

pgSaci keeps every user's objects in a shared PostgreSQL oracle schema. The
SYS.ALL_* / USER_* catalog facade was exposing that literally as owner
ORACLE, and sys.all_users never listed the login role — so DataGrip /
IntelliJ (which assume Oracle's "schema == user" model) showed no node for the
connected user and none of their tables.

  • all_* / user_* facade views now report objects in the oracle schema as
    owned by current_user; user_* filters follow the same mapping.
  • sys.all_users lists the connected user; the per-package schemas orafce
    creates (dbms_*, plv*, utl_file, plunit) are filtered out.
  • PostgreSQL 18 catalogues NOT NULL as pg_constraint.contype = 'n' — mapped
    to Oracle constraint_type = 'C' with a NOT NULL <col> search condition
    instead of leaking the raw 'n'.
  • dbms_metadata.get_ddl(type, name, schema): when schema is the connected
    user, resolve against the oracle schema.

Also in this line: CONNECT BY on NUMBER(p)-typed key columns (v0.0.3) —
the WITH RECURSIVE ancestor-path array had a typmod mismatch between the
union arms, breaking any hierarchy keyed on a precision-qualified NUMBER.

docker pull levyks/pgsaci:0.0.4 — digest sha256:5ffd5c107452…, 9.77 MB.