# 0.5.4.0
## Added features
* Better error messages on column type mismatches (#696).
* Added support for creating and dropping database schemas and associated tables with `createDatabaseSchema`, `dropDatabaseSchema`, `` and `createTableWithSchema` (#716).
## Documentation
* Make `runBeamPostgres` and `runBeamPostgresDebug` easier to find (#663).
# 0.5.3.1
## Added features
* Loosen some version bounds
# 0.5.3.0
## Bug fixes
* Make sure lateral join names do not overlap
* Fix `bool_or`
## Addded features
* Add `runSelectReturningFirst`
* `IN (SELECT ...)` syntax via `inQuery_`
# 0.5.2.1
## Added features
* Aeson 2.0 support
# 0.5.2.0
## Added features
* New `conduit` streaming variants which work directly in `MonadResource`
* Heterogeneous variant of `ilike_`: `ilike_'`
* Postgres-specific `EXTRACT` fields
* GHC 9.2 and 9.0 support
## Bug fixes
* Throw correct exception for row errors in `conduit` implementation
* Support emitting UUID values in context where type cannot be inferred by Postgres
# 0.5.1.0
## Added features
* `MonadBase` and `MonadBaseControl` instances for `Pg`
## Bug fixes
* Fix possible memory corruption by copying row data
* Remove invalid parentheses emitted by `pgUnnest`
# 0.5.0.0
## Interface changes
* Removed instances for machine-dependent ambiguous integer types `Int` and `Word`
* Fixed types for some functions that only work with `jsonb` and not `json`
## Added features
* Support for `in_` on row values
* Various Postgres regex functions
* Expose `fromPgIntegral` and `fromPgScientificOrIntegral`
* Add `liftIOWithHandle :: (Connection -> IO a) -> Pg a`
* Add `getDbConstraintsForSchemas` to get constraints without relying on the state of the connection
* Poly-kinded instances for `Data.Tagged.Tagged`
* Add `HasDefaultDatatype` for `UTCTime`
* Support for specifically-sized `SqlSerial` integers (`smallserial`, `serial`, `bigserial`)
* Predicate detection for extensions
* `pgArrayToJson` for `array_to_json`
* Extension definition and all functions provided by `uuid-ossp`
* GHC 8.8 support
## Bug fixes
* Only detect primary keys of tables in visible schemas
* Fix emitting of `DECIMAL` type
* Report JSON correct decoding errors instead of throwing `UnexpectedNull`
## Behavior changes
* `runReturningOne` and `runResturningList` now fetch all rows at once instead of using cursors
# 0.4.0.0
# 0.3.2.0
Add `Semigroup` instances to prepare for GHC 8.4 and Stackage nightly
# 0.3.1.0
Add `runBeamPostgres` and `runBeamPostgresDebug` functions.
# 0.3.0.0
Initial hackage beam-postgres