:: a typeCtrl KGHC 9.10.3 · lts/ghc-9.10.x · 248f8f0 · 2026-10-05
Modulepostgresql-simple-0.7.0.0Haskell2010
Execute an action inside a SQL transaction.
This function initiates a transaction with a "begin
transaction" statement, then executes the supplied action. If
the action succeeds, the transaction will be completed with
Base.commit before this function returns.
If the action throws any kind of exception (not just a PostgreSQL-related exception), the transaction will be rolled back using rollback, then the exception will be rethrown.
For nesting transactions, see withSavepoint.
Execute an action inside a SQL transaction with a given isolation level.
Execute an action inside a SQL transaction with a given transaction mode.
withTransactionModeRetry' but with the exception type pinned to SqlError.
Like withTransactionMode, but also takes a custom callback to
determine if a transaction should be retried if an exception occurs.
If the callback returns True, then the transaction will be retried.
If the callback returns False, or an exception other than an e
occurs then the transaction will be rolled back and the exception rethrown.
This is used to implement withTransactionSerializable.
Execute an action inside of a Serializable transaction. If a serialization failure occurs, roll back the transaction and try again. Be warned that this may execute the IO action multiple times.
A Serializable transaction creates the illusion that your program has exclusive access to the database. This means that, even in a concurrent setting, you can perform queries in sequence without having to worry about what might happen between one statement and the next.
Think of it as STM, but without retry.
Eq TransactionModeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionShow TransactionModeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionOf the four isolation levels defined by the SQL standard, these are the three levels distinguished by PostgreSQL as of version 9.0. See https://www.postgresql.org/docs/9.5/static/transaction-iso.html for more information. Note that prior to PostgreSQL 9.0, RepeatableRead was equivalent to Serializable.
DefaultIsolationLevelthe isolation level will be taken from
PostgreSQL's per-connection
default_transaction_isolation variable,
which is initialized according to the
server's config. The default configuration
is ReadCommitted.
ReadCommittedRepeatableReadSerializableBounded IsolationLevelDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionEnum IsolationLevelDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionEq IsolationLevelDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionOrd IsolationLevelDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionShow IsolationLevelDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionDefaultReadWriteModethe read-write mode will be taken from
PostgreSQL's per-connection
default_transaction_read_only variable,
which is initialized according to the
server's config. The default configuration
is ReadWrite.
ReadWriteReadOnlyBounded ReadWriteModeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionEnum ReadWriteModeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionEq ReadWriteModeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionOrd ReadWriteModeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionShow ReadWriteModeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TransactionBegin a transaction.
Begin a transaction with a given isolation level
Begin a transaction with a given transaction mode
Commit a transaction.
Rollback a transaction.
Create a savepoint, and roll back to it if an error occurs. This may only be used inside of a transaction, and provides a sort of "nested transaction".
See https://www.postgresql.org/docs/9.5/static/sql-savepoint.html
Eq SavepointDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TypesOrd SavepointDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TypesRead SavepointDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TypesShow SavepointDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.TypesCreate a new savepoint. This may only be used inside of a transaction.
Destroy a savepoint, but retain its effects.
Warning: this will throw a SqlError matching isFailedTransactionError if the transaction is aborted due to an error. commit would merely warn and roll back.
Roll back to a savepoint. This will not release the savepoint.
Roll back to a savepoint and release it. This is like calling rollbackToSavepoint followed by releaseSavepoint, but avoids a round trip to the database server.