Changelog for persistent-postgresql

2.10.0

Added question mark operators ((?.), (?|.), (?&.)) to Database.Persist.Postgresql.JSON #863
Changes to certain types:
- PersistValue: added PersistArray data constructor
- Filter: Changed the filterValue :: Either a [a] to filterValue :: FilterValue

2.9.1

Add openSimpleConnWithVersion function. #883

2.9.0

Added support for SQL isolation levels to via SqlBackend. [#812]
Fix 832: repsertMany now matches mapM_ (uncurry repsert) and is atomic.

2.8.2

Added module Database.Persist.Postgresql.JSON #793

PersistField and PersistFieldSql instances for Data.Aeson.Value
Filter operators (@>.) and (<@.) to filter on JSON values

2.8.1.1

Added a more detailed error message when a numeric column's scale and precision can't be parsed. #781

2.8.1

Implemented connPutManySql to utilize batched putMany. #770

2.8.0

Switch from MonadBaseControl to MonadUnliftIO

2.6.3

Added new function migrateEnableExtension, to enable Postgres extensions in migrations.

2.6.2.2

Because text and varchar are synonyms in Postgresql, don't attempt to migrate between them. #762

2.6.2.1

Fix bug where, if a custom column width was set, the field would be migrated every time #742

2.6.2

Expose new functions: withPostgresqlPoolWithVersion, withPostgresqlConnWithVersion and createPostgresqlPoolModifiedWithVersion.

2.6.1

Match changes in persistent
Clean up warnings

2.6

Atomic upsert support for postgreSQL backend

2.5

changes for read/write typeclass split

2.2.2

Postgresql primary key is Int4, not Int8 #519

2.2.1.2

Allow postgresql-simple 0.5

2.2.1.1

Query pg_catalog instead of information_schema for metadata. This helps with permission issues as reported in issue #501

2.2.1

Fix treatment of NULLs inside arrays. For example, now you can use array_agg on a nullable column.
New derived instances for PostgresConf: Read, Data and Typeable.
New mockMigration function. Works like printMigration but doesn't need a database connection.
Fix typo on error message of the FromJSON instance of PostgresConf.

2.2

Optimize the insertMany function to insert all rows and retrieve their keys in one SQL query. #407

2.1.6

Postgresql exceptions #353

2.1.5.3

Migrations for custom primary keys

2.1.5.2

Support foreign key references to composite primary keys #389

2.1.5

Allow timestamp value in database to be serialized (presumes UTC timezone) Yesod #391

2.1.4

Treat unknown extension types as PersistDbSpecific values #385

2.1.3

Added a Show instance for PostgresConf.
createPostgresqlPoolModified added, see relevant mailing list discussion

2.1.2.1

Documentation typo fix

2.1.1

Added FromJSON instance for PostgresConf.