PostgreSQL v7.0.0 Release Notes

  • 💥 Breaking Changes

    • ⬇️ Drop support for node < 4.x.
    • ✂ Remove pg.connect pg.end and pg.cancel singleton methods.
    • Client#connect(callback) now returns undefined. It used to return an event emitter.
    • ⬆️ Upgrade pg-pool to 2.x.
    • ⬆️ Upgrade pg-native to 2.x.
    • Standardize error message fields between JS and native driver. The only breaking changes were in the native driver as its field names were brought into alignment with the existing JS driver field names.
    • Result from multi-statement text queries such as SELECT 1; SELECT 2; are now returned as an array of results instead of a single result with 1 array containing rows from both queries.

    ⬆️ Please see here for a migration guide

    ✨ Enhancements

    • 📚 Overhauled documentation: https://node-postgres.com.
    • Add Client#connect() => Promise<void> and Client#end() => Promise<void> calls. Promises are now returned from all async methods on clients if and only if no callback was supplied to the method.
    • ➕ Add connectionTimeoutMillis to pg-pool.