Release v0.3.0 · drummonds/go-postgres

v0.3.0

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

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)

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: v0.2.1...v0.3.0