Changelog for persistent-postgresql

2.14.0.0

• #1604
  • Changed the representation of intervals to use the Interval type from the postgresql-simple-interval package. This changes the behavior of PgInterval for very small and very large values.
  • Previously PgInterval 0.000_000_9 would be rounded to 0.000_001 seconds, but now it is truncated to 0 seconds.
  • Previously PgInterval 9_223_372_036_854.775_808 would overflow and throw a SQL error, but now it saturates to 9_223_372_036_854.775_807 seconds.
  • The SQL representation of PgInterval now always includes the interval prefix, like interval '1 second'.

2.13.7.0

• #1600
  • Add migrateStructured to Database.Persist.Postgresql.Internal. This allows you to access a structured representation of the proposed migrations for use in your application.
• #1547
  • Bump libpq bounds

2.13.6.2

• #1536
  • Build with GHC 9.10

2.13.6.1

• #1518
  • Normalize postgres type aliases to prevent noop migrations

2.13.6

• #1511
  • Add the createPostgresqlPoolTailored function to support creating connection pools with a custom connection creation function.
  • Expose getServerVersion and createBackend for user’s convenience.
• #1516
  • Support postgresql-simple 0.7 and postgresql-libpq 0.10

2.13.5.2

• #1471
  • Explicitly import Control.Monad.Trans.lift to support mtl-2.3.

2.13.5.1

• #1459
  • Make use of CautiousMigration type alias for clarity.

2.13.5.0

• #1362
  • Define withPostgresqlPoolModifiedWithVersion

2.13.4.1

• #1367, #1366, #1338, #1335
  • Support GHC 9.2

2.13.4.0

• #1341
  • Add SqlBackendHooks to allow for instrumentation of queries.
• #1327
  • Update backend to support new StatementCache interface

2.13.3.0

• #1349
  • Add BackendCompatible (RawPostgresql b) (RawPostgresql b) instance.

2.13.2.2

• #1351
  • Support aeson-2.0 in test suite.

2.13.2.1

• #1331
  • Fixes a bug where upsertWhere would fail on a database table with MigrationOnly fields.

2.13.2.0

• #1316
  • Expose some internals in the new Database.Persist.Postgresql.Internal module. This gives access to the P newtype, which is used for de-serializing PersistValues from postgresql-simple code.

2.13.1.0

• #1305
  • Add RawPostgresql wrapper, which exposes the underlying Postgres connection used to construct a SqlBackend.

2.13.0.3

• #1290
  • Fix the code path for adding references to previously defined columns.

2.13.0.2

• Actually release the SafeTORemove fix

2.13.0.1

• #1275
  • Fix SafeToRemove

2.13.0.0

• #1225
  • Support persistent-2.13.0.0 making SQlBackend internal

2.12.1.1

• #1235
  • upsertWhere and upsertManyWhere only worked in cases where a Primary key was defined on a record, and no other uniqueness constraints. They have been fixed to only work with records that have a single Uniqueness constraint defined.

2.12.1.0

• Added upsertWhere and upsertManyWhere to persistent-postgresql. #1222.

2.12.0.0

• Decomposed HaskellName into ConstraintNameHS, EntityNameHS, FieldNameHS. Decomposed DBName into ConstraintNameDB, EntityNameDB, FieldNameDB respectively. #1174
• Fix XML conversion #1192

2.11.0.1

• Fix foreign key migrations [#1167] https://github.com/yesodweb/persistent/pull/1167
  • Fix a bug where a foreign key of a field to its table was ignored.
  • Fix a bug where a altering details of a foreign key didn’t trigger a migration

2.11.0.0

• Foreign Key improvements [#1121] https://github.com/yesodweb/persistent/pull/1121
  • It is now supported to refer to a table with an auto generated Primary Kay
  • It is now supported to refer to non-primary fields, using the keyword References
• Implement interval support. #1053
• #1060
  • The QuasiQuoter now supports OnDelete and OnUpdate cascade options.
• Handle foreign key constraint names over 63 characters. See #996 for details.
• Fix a bug in upsertSql query which had not been discovered previously because the query wasn’t actually used. #856
• #1072 Refactored test/JSONTest.hs to use hspec
  • added runConn_ to run a db connection and return result
  • Renamed db to runConnAssert in test/PgInit.hs for clarity
  • Ran test/ArrayAggTest.hs (which was previously written but not being run)
• Remove unnecessary deriving of Typeable #1114
• Add support for configuring the number of stripes and idle timeout for connection pools #1098
  • PostgresConf has two new fields to configure these values.
    • Its FromJSON instance will default stripes to 1 and idle timeout to 600 seconds
    • If you’re constructing a PostgresConf manually, this is a breaking change
  • Add createPostgresqlPoolWithConf and withPostgresqlPoolWithConf, which take a PostgresConf for the new configuration.

2.10.1.2

• Fix issue with multiple foreign keys on single column. #1010

2.10.1.1

• Compatibility with latest persistent-template for test suite #1002

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.