Skip to content

v0.0.8

Latest

Choose a tag to compare

@Levyks Levyks released this 03 Sep 14:43
· 76 commits to main since this release

Session time zones, done the way Oracle does them.

What changed

  • ALTER SESSION SET TIME_ZONE accepts a named IANA region
    ('America/Sao_Paulo'), a fixed offset ('-03:00'), or 'local'.
  • TIMESTAMPTZ values are converted to the session zone on the wire — with
    per-instant, DST-correct offsets for named regions — instead of coming back in
    UTC. Views no longer need AT TIME ZONE / ::timestamp casts, and the Oracle
    JDBC thin driver no longer needs oracle.jdbc.timezoneAsRegion=false. PG
    timestamp (no zone) is unchanged.
  • SESSIONTIMEZONE, DBTIMEZONE (usable without parens),
    SYS_CONTEXT('USERENV','SESSIONTIMEZONE' | 'DB_TIMEZONE').
  • Preflight also drops a stale oracle.sys_context left by pre-0.0.5 builds,
    which shadowed the current public.sys_context.

Note

New chrono-tz dependency bundles the IANA time-zone database (pure Rust). The
image stays a static musl binary on scratch, now ~12 MB (was ~10).

New corpus group time_zones.sql (13 cases). corpus 664 → 675.

docker pull levyks/pgsaci:0.0.8