Changelog for persistent-postgresql

2.10.1

• Added support for the constraint= attribute to the Postgresql backend. #979

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.