hum3/go-postgres
Watch
1
0
Fork
You've already forked go-postgres
 0
Code Issues 6 Pull requests Projects Releases 1 Packages Wiki Activity Actions
1 release 16 tags
  • v0.3.0 1143a01eaa

    v0.3.0 Stable

    hum3 released this 2026-02-08 01:05:42 +00:00 | 41 commits to main since this release

    v0.3.0

    This release resolves all 6 open issues, improving compatibility between PostgreSQL SQL and the underlying SQLite engine.

    Bug Fixes

    • Fix SERIAL PRIMARY KEY generating duplicate PRIMARY KEY in SQLite (#1) — SERIAL PRIMARY KEY DDL no longer emits a redundant PRIMARY KEY constraint that caused SQLite errors. (b09e1e8)
    • Fix DEFAULT CURRENT_TIMESTAMP not wrapped in parentheses for SQLite (#2) — DEFAULT CURRENT_TIMESTAMP is now correctly parenthesized so SQLite accepts it. (1c85a64)
    • Coerce SQLite timestamp strings to time.Time on Scan (#3) — Timestamp values returned by SQLite are now automatically coerced to time.Time when scanned, matching PostgreSQL driver behavior. (3b50013)
    • Fix NULLS FIRST/LAST for table-qualified and expression columns (#4) — ORDER BY with NULLS FIRST / NULLS LAST now works correctly for table-qualified columns (e.g., t.col) and complex expressions. (fa1c61f)

    Improvements

    • Verify INSERT RETURNING works via SQLite 3.35+ (#5) — Added tests confirming that INSERT ... RETURNING is supported natively by the bundled SQLite version (3.35+). (7f362eb)
    • Add ALTER TABLE ADD COLUMN IF NOT EXISTS support (#6) — ALTER TABLE ... ADD COLUMN IF NOT EXISTS is now translated to SQLite-compatible SQL. (1143a01)

    Full Changelog: https://github.com/drummonds/go-postgres/compare/v0.2.1...v0.3.0

    Migrated from the GitHub mirror (https://github.com/drummonds/go-postgres/releases/tag/v0.3.0).

    Downloads