Database.PostgreSQL.Simple.Transaction

Transaction handling

withTransaction :: Connection -> IO a -> IO a

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 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.

withTransactionLevel :: IsolationLevel -> Connection -> IO a -> IO a

Execute an action inside a SQL transaction with a given isolation level.

withTransactionMode :: TransactionMode -> Connection -> IO a -> IO a

Execute an action inside a SQL transaction with a given transaction mode.

withTransactionModeRetry :: TransactionMode -> (SqlError -> Bool) -> Connection -> IO a -> IO a

Like withTransactionMode, but also takes a custom callback to determine if a transaction should be retried if an SqlError occurs. If the callback returns True, then the transaction will be retried. If the callback returns False, or an exception other than an SqlError occurs then the transaction will be rolled back and the exception rethrown.

This is used to implement withTransactionSerializable.

withTransactionSerializable :: Connection -> IO a -> IO a

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.

data TransactionMode

Constructors

TransactionMode

Fields

• isolationLevel :: !IsolationLevel
• readWriteMode :: !ReadWriteMode

Instances

Eq TransactionMode

Methods

(==) :: TransactionMode -> TransactionMode -> Bool

(/=) :: TransactionMode -> TransactionMode -> Bool

Show TransactionMode

Methods

showsPrec :: Int -> TransactionMode -> ShowS

show :: TransactionMode -> String

showList :: [TransactionMode] -> ShowS

data IsolationLevel

Of 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.

Constructors

DefaultIsolationLevel

the 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.

ReadCommitted

RepeatableRead

Serializable

Instances

Bounded IsolationLevel

Methods

minBound :: IsolationLevel

maxBound :: IsolationLevel

Enum IsolationLevel

Methods

succ :: IsolationLevel -> IsolationLevel

pred :: IsolationLevel -> IsolationLevel

toEnum :: Int -> IsolationLevel

fromEnum :: IsolationLevel -> Int

enumFrom :: IsolationLevel -> [IsolationLevel]

enumFromThen :: IsolationLevel -> IsolationLevel -> [IsolationLevel]

enumFromTo :: IsolationLevel -> IsolationLevel -> [IsolationLevel]

enumFromThenTo :: IsolationLevel -> IsolationLevel -> IsolationLevel -> [IsolationLevel]

Eq IsolationLevel

Methods

(==) :: IsolationLevel -> IsolationLevel -> Bool

(/=) :: IsolationLevel -> IsolationLevel -> Bool

Ord IsolationLevel

Methods

compare :: IsolationLevel -> IsolationLevel -> Ordering

(<) :: IsolationLevel -> IsolationLevel -> Bool

(<=) :: IsolationLevel -> IsolationLevel -> Bool

(>) :: IsolationLevel -> IsolationLevel -> Bool

(>=) :: IsolationLevel -> IsolationLevel -> Bool

max :: IsolationLevel -> IsolationLevel -> IsolationLevel

min :: IsolationLevel -> IsolationLevel -> IsolationLevel

Show IsolationLevel

Methods

showsPrec :: Int -> IsolationLevel -> ShowS

show :: IsolationLevel -> String

showList :: [IsolationLevel] -> ShowS

data ReadWriteMode

Constructors

DefaultReadWriteMode

the 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.

ReadWrite

ReadOnly

Instances

Bounded ReadWriteMode

Methods

minBound :: ReadWriteMode

maxBound :: ReadWriteMode

Enum ReadWriteMode

Methods

succ :: ReadWriteMode -> ReadWriteMode

pred :: ReadWriteMode -> ReadWriteMode

toEnum :: Int -> ReadWriteMode

fromEnum :: ReadWriteMode -> Int

enumFrom :: ReadWriteMode -> [ReadWriteMode]

enumFromThen :: ReadWriteMode -> ReadWriteMode -> [ReadWriteMode]

enumFromTo :: ReadWriteMode -> ReadWriteMode -> [ReadWriteMode]

enumFromThenTo :: ReadWriteMode -> ReadWriteMode -> ReadWriteMode -> [ReadWriteMode]

Eq ReadWriteMode

Methods

(==) :: ReadWriteMode -> ReadWriteMode -> Bool

(/=) :: ReadWriteMode -> ReadWriteMode -> Bool

Ord ReadWriteMode

Methods

compare :: ReadWriteMode -> ReadWriteMode -> Ordering

(<) :: ReadWriteMode -> ReadWriteMode -> Bool

(<=) :: ReadWriteMode -> ReadWriteMode -> Bool

(>) :: ReadWriteMode -> ReadWriteMode -> Bool

(>=) :: ReadWriteMode -> ReadWriteMode -> Bool

max :: ReadWriteMode -> ReadWriteMode -> ReadWriteMode

min :: ReadWriteMode -> ReadWriteMode -> ReadWriteMode

Show ReadWriteMode

Methods

showsPrec :: Int -> ReadWriteMode -> ShowS

show :: ReadWriteMode -> String

showList :: [ReadWriteMode] -> ShowS

defaultTransactionMode :: TransactionMode

defaultIsolationLevel :: IsolationLevel

defaultReadWriteMode :: ReadWriteMode

begin :: Connection -> IO ()

Begin a transaction.

beginLevel :: IsolationLevel -> Connection -> IO ()

Begin a transaction with a given isolation level

beginMode :: TransactionMode -> Connection -> IO ()

Begin a transaction with a given transaction mode

commit :: Connection -> IO ()

Commit a transaction.

rollback :: Connection -> IO ()

Rollback a transaction.

Savepoint

withSavepoint :: Connection -> IO a -> IO a

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

data Savepoint

Instances

Eq Savepoint

Methods

(==) :: Savepoint -> Savepoint -> Bool

(/=) :: Savepoint -> Savepoint -> Bool

Ord Savepoint

Methods

compare :: Savepoint -> Savepoint -> Ordering

(<) :: Savepoint -> Savepoint -> Bool

(<=) :: Savepoint -> Savepoint -> Bool

(>) :: Savepoint -> Savepoint -> Bool

(>=) :: Savepoint -> Savepoint -> Bool

max :: Savepoint -> Savepoint -> Savepoint

min :: Savepoint -> Savepoint -> Savepoint

Read Savepoint

Methods

readsPrec :: Int -> ReadS Savepoint

readList :: ReadS [Savepoint]

readPrec :: ReadPrec Savepoint

readListPrec :: ReadPrec [Savepoint]

Show Savepoint

Methods

showsPrec :: Int -> Savepoint -> ShowS

show :: Savepoint -> String

showList :: [Savepoint] -> ShowS

newSavepoint :: Connection -> IO Savepoint

Create a new savepoint. This may only be used inside of a transaction.

releaseSavepoint :: Connection -> Savepoint -> IO ()

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.

rollbackToSavepoint :: Connection -> Savepoint -> IO ()

Roll back to a savepoint. This will not release the savepoint.

rollbackToAndReleaseSavepoint :: Connection -> Savepoint -> IO ()

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.

Error predicates

isSerializationError :: SqlError -> Bool

isNoActiveTransactionError :: SqlError -> Bool

isFailedTransactionError :: SqlError -> Bool