Safe Haskell	None
Language	Haskell2010

Database.PostgreSQL.PQTypes

Contents

Connection
Exceptions
Monad transformer
Query result
Other modules

Description

Set of definitions exposed to the end user.

Synopsis

data Connection
data ConnectionStats = ConnectionStats {
- statsQueries :: !Int
- statsRows :: !Int
- statsValues :: !Int
- statsParams :: !Int
}
data ConnectionSettings = ConnectionSettings {
- csConnInfo :: !Text
- csClientEncoding :: !(Maybe Text)
- csComposites :: ![Text]
}
data ConnectionSourceM m
newtype ConnectionSource (cs :: [(* -> *) -> Constraint]) = ConnectionSource {
- unConnectionSource :: forall m. MkConstraint m cs => ConnectionSourceM m
}
simpleSource :: ConnectionSettings -> ConnectionSource [MonadBase IO, MonadMask]
poolSource :: ConnectionSettings -> Int -> NominalDiffTime -> Int -> IO (ConnectionSource [MonadBase IO, MonadMask])
data ErrorCode
- = SuccessfulCompletion
- | Warning
- | DynamicResultSetsReturned
- | ImplicitZeroBitPadding
- | NullValueEliminatedInSetFunction
- | PrivilegeNotGranted
- | PrivilegeNotRevoked
- | StringDataRightTruncation_01
- | DeprecatedFeature
- | NoData
- | NoAdditionalDynamicResultSetsReturned
- | SqlStatementNotYetComplete
- | ConnectionException
- | ConnectionDoesNotExist
- | ConnectionFailure
- | SqlclientUnableToEstablishSqlconnection
- | SqlserverRejectedEstablishmentOfSqlconnection
- | TransactionResolutionUnknown
- | ProtocolViolation
- | TriggeredActionException
- | FeatureNotSupported
- | InvalidTransactionInitiation
- | LocatorException
- | InvalidLocatorSpecification
- | InvalidGrantor
- | InvalidGrantOperation
- | InvalidRoleSpecification
- | DiagnosticsException
- | StackedDiagnosticsAccessedWithoutActiveHandler
- | CaseNotFound
- | CardinalityViolation
- | DataException
- | ArraySubscriptError
- | CharacterNotInRepertoire
- | DatetimeFieldOverflow
- | DivisionByZero
- | ErrorInAssignment
- | EscapeCharacterConflict
- | IndicatorOverflow
- | IntervalFieldOverflow
- | InvalidArgumentForLogarithm
- | InvalidArgumentForNtileFunction
- | InvalidArgumentForNthValueFunction
- | InvalidArgumentForPowerFunction
- | InvalidArgumentForWidthBucketFunction
- | InvalidCharacterValueForCast
- | InvalidDatetimeFormat
- | InvalidEscapeCharacter
- | InvalidEscapeOctet
- | InvalidEscapeSequence
- | NonstandardUseOfEscapeCharacter
- | InvalidIndicatorParameterValue
- | InvalidParameterValue
- | InvalidRegularExpression
- | InvalidRowCountInLimitClause
- | InvalidRowCountInResultOffsetClause
- | InvalidTimeZoneDisplacementValue
- | InvalidUseOfEscapeCharacter
- | MostSpecificTypeMismatch
- | NullValueNotAllowed_22
- | NullValueNoIndicatorParameter
- | NumericValueOutOfRange
- | StringDataLengthMismatch
- | StringDataRightTruncation_22
- | SubstringError
- | TrimError
- | UnterminatedCString
- | ZeroLengthCharacterString
- | FloatingPointException
- | InvalidTextRepresentation
- | InvalidBinaryRepresentation
- | BadCopyFileFormat
- | UntranslatableCharacter
- | NotAnXmlDocument
- | InvalidXmlDocument
- | InvalidXmlContent
- | InvalidXmlComment
- | InvalidXmlProcessingInstruction
- | IntegrityConstraintViolation
- | RestrictViolation
- | NotNullViolation
- | ForeignKeyViolation
- | UniqueViolation
- | CheckViolation
- | ExclusionViolation
- | InvalidCursorState
- | InvalidTransactionState
- | ActiveSqlTransaction
- | BranchTransactionAlreadyActive
- | HeldCursorRequiresSameIsolationLevel
- | InappropriateAccessModeForBranchTransaction
- | InappropriateIsolationLevelForBranchTransaction
- | NoActiveSqlTransactionForBranchTransaction
- | ReadOnlySqlTransaction
- | SchemaAndDataStatementMixingNotSupported
- | NoActiveSqlTransaction
- | InFailedSqlTransaction
- | InvalidSqlStatementName
- | TriggeredDataChangeViolation
- | InvalidAuthorizationSpecification
- | InvalidPassword
- | DependentPrivilegeDescriptorsStillExist
- | DependentObjectsStillExist
- | InvalidTransactionTermination
- | SqlRoutineException
- | FunctionExecutedNoReturnStatement
- | ModifyingSqlDataNotPermitted_2F
- | ProhibitedSqlStatementAttempted_2F
- | ReadingSqlDataNotPermitted_2F
- | InvalidCursorName
- | ExternalRoutineException
- | ContainingSqlNotPermitted
- | ModifyingSqlDataNotPermitted_38
- | ProhibitedSqlStatementAttempted_38
- | ReadingSqlDataNotPermitted_38
- | ExternalRoutineInvocationException
- | InvalidSqlstateReturned
- | NullValueNotAllowed_39
- | TriggerProtocolViolated
- | SrfProtocolViolated
- | SavepointException
- | InvalidSavepointSpecification
- | InvalidCatalogName
- | InvalidSchemaName
- | TransactionRollback
- | TransactionIntegrityConstraintViolation
- | SerializationFailure
- | StatementCompletionUnknown
- | DeadlockDetected
- | SyntaxErrorOrAccessRuleViolation
- | SyntaxError
- | InsufficientPrivilege
- | CannotCoerce
- | GroupingError
- | WindowingError
- | InvalidRecursion
- | InvalidForeignKey
- | InvalidName
- | NameTooLong
- | ReservedName
- | DatatypeMismatch
- | IndeterminateDatatype
- | CollationMismatch
- | IndeterminateCollation
- | WrongObjectType
- | UndefinedColumn
- | UndefinedFunction
- | UndefinedTable
- | UndefinedParameter
- | UndefinedObject
- | DuplicateColumn
- | DuplicateCursor
- | DuplicateDatabase
- | DuplicateFunction
- | DuplicatePreparedStatement
- | DuplicateSchema
- | DuplicateTable
- | DuplicateAlias
- | DuplicateObject
- | AmbiguousColumn
- | AmbiguousFunction
- | AmbiguousParameter
- | AmbiguousAlias
- | InvalidColumnReference
- | InvalidColumnDefinition
- | InvalidCursorDefinition
- | InvalidDatabaseDefinition
- | InvalidFunctionDefinition
- | InvalidPreparedStatementDefinition
- | InvalidSchemaDefinition
- | InvalidTableDefinition
- | InvalidObjectDefinition
- | WithCheckOptionViolation
- | InsufficientResources
- | DiskFull
- | OutOfMemory
- | TooManyConnections
- | ConfigurationLimitExceeded
- | ProgramLimitExceeded
- | StatementTooComplex
- | TooManyColumns
- | TooManyArguments
- | ObjectNotInPrerequisiteState
- | ObjectInUse
- | CantChangeRuntimeParam
- | LockNotAvailable
- | OperatorIntervention
- | QueryCanceled
- | AdminShutdown
- | CrashShutdown
- | CannotConnectNow
- | DatabaseDropped
- | SystemError
- | IoError
- | UndefinedFile
- | DuplicateFile
- | ConfigFileError
- | LockFileExists
- | FdwError
- | FdwColumnNameNotFound
- | FdwDynamicParameterValueNeeded
- | FdwFunctionSequenceError
- | FdwInconsistentDescriptorInformation
- | FdwInvalidAttributeValue
- | FdwInvalidColumnName
- | FdwInvalidColumnNumber
- | FdwInvalidDataType
- | FdwInvalidDataTypeDescriptors
- | FdwInvalidDescriptorFieldIdentifier
- | FdwInvalidHandle
- | FdwInvalidOptionIndex
- | FdwInvalidOptionName
- | FdwInvalidStringLengthOrBufferLength
- | FdwInvalidStringFormat
- | FdwInvalidUseOfNullPointer
- | FdwTooManyHandles
- | FdwOutOfMemory
- | FdwNoSchemas
- | FdwOptionNameNotFound
- | FdwReplyHandle
- | FdwSchemaNotFound
- | FdwTableNotFound
- | FdwUnableToCreateExecution
- | FdwUnableToCreateReply
- | FdwUnableToEstablishConnection
- | PlpgsqlError
- | RaiseException
- | NoDataFound
- | TooManyRows
- | InternalError
- | DataCorrupted
- | IndexCorrupted
- | UnknownErrorCode String
data DetailedQueryError = DetailedQueryError {
- qeSeverity :: !String
- qeErrorCode :: !ErrorCode
- qeMessagePrimary :: !String
- qeMessageDetail :: !(Maybe String)
- qeMessageHint :: !(Maybe String)
- qeStatementPosition :: !(Maybe Int)
- qeInternalPosition :: !(Maybe Int)
- qeInternalQuery :: !(Maybe String)
- qeContext :: !(Maybe String)
- qeSourceFile :: !(Maybe String)
- qeSourceLine :: !(Maybe Int)
- qeSourceFunction :: !(Maybe String)
}
newtype QueryError = QueryError String
newtype HPQTypesError = HPQTypesError String
newtype LibPQError = LibPQError String
data ConversionError = Exception e => ConversionError {
- convColumn :: !Int
- convColumnName :: !String
- convRow :: !Int
- convError :: !e
}
data ArrayItemError = Exception e => ArrayItemError {
- arrItemIndex :: !Int
- arrItemError :: !e
}
data InvalidValue t = InvalidValue {
- ivValue :: t
- ivValidValues :: Maybe [t]
}
data RangeError t = RangeError {
- reRange :: [(t, t)]
- reValue :: t
}
data ArrayDimensionMismatch = ArrayDimensionMismatch {
- arrDimExpected :: !Int
- arrDimDelivered :: !Int
}
data RowLengthMismatch = RowLengthMismatch {
- lengthExpected :: !Int
- lengthDelivered :: !Int
}
data AffectedRowsMismatch = AffectedRowsMismatch {
- rowsExpected :: ![(Int, Int)]
- rowsDelivered :: !Int
}
data DBException = (Exception e, Show sql) => DBException {
- dbeQueryContext :: !sql
- dbeError :: !e
}
type DBT m = DBT_ m m
runDBT :: (MonadBase IO m, MonadMask m) => ConnectionSourceM m -> TransactionSettings -> DBT m a -> m a
mapDBT :: (DBState n -> DBState m) -> (m (a, DBState m) -> n (b, DBState n)) -> DBT m a -> DBT n b
data QueryResult t
ntuples :: QueryResult t -> Int
nfields :: QueryResult t -> Int
module Data.Functor.Identity
module Database.PostgreSQL.PQTypes.Array
module Database.PostgreSQL.PQTypes.Class
module Database.PostgreSQL.PQTypes.Composite
module Database.PostgreSQL.PQTypes.Fold
module Database.PostgreSQL.PQTypes.Format
module Database.PostgreSQL.PQTypes.FromRow
module Database.PostgreSQL.PQTypes.FromSQL
module Database.PostgreSQL.PQTypes.Interval
module Database.PostgreSQL.PQTypes.JSON
module Database.PostgreSQL.PQTypes.Notification
module Database.PostgreSQL.PQTypes.SQL
module Database.PostgreSQL.PQTypes.SQL.Class
module Database.PostgreSQL.PQTypes.SQL.Raw
module Database.PostgreSQL.PQTypes.ToRow
module Database.PostgreSQL.PQTypes.ToSQL
module Database.PostgreSQL.PQTypes.Transaction
module Database.PostgreSQL.PQTypes.Transaction.Settings
module Database.PostgreSQL.PQTypes.Utils
module Database.PostgreSQL.PQTypes.XML

Connection

data Connection Source #

Wrapper for hiding representation of a connection object.

data ConnectionStats Source #

Simple connection statistics.

Constructors

ConnectionStats
Fields statsQueries :: !Int Number of queries executed so far. statsRows :: !Int Number of rows fetched from the database. statsValues :: !Int Number of values fetched from the database. statsParams :: !Int Number of parameters sent to the database.

Instances

Eq ConnectionStats Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Connection Methods (==) :: ConnectionStats -> ConnectionStats -> Bool # (/=) :: ConnectionStats -> ConnectionStats -> Bool #
Ord ConnectionStats Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Connection Methods compare :: ConnectionStats -> ConnectionStats -> Ordering # (<) :: ConnectionStats -> ConnectionStats -> Bool # (<=) :: ConnectionStats -> ConnectionStats -> Bool # (>) :: ConnectionStats -> ConnectionStats -> Bool # (>=) :: ConnectionStats -> ConnectionStats -> Bool # max :: ConnectionStats -> ConnectionStats -> ConnectionStats # min :: ConnectionStats -> ConnectionStats -> ConnectionStats #
Show ConnectionStats Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Connection Methods showsPrec :: Int -> ConnectionStats -> ShowS # show :: ConnectionStats -> String # showList :: [ConnectionStats] -> ShowS #

data ConnectionSettings Source #

Constructors

ConnectionSettings
Fields csConnInfo :: !Text Connection info string. csClientEncoding :: !(Maybe Text) Client-side encoding. If set to `Nothing`, database encoding is used. csComposites :: ![Text] A list of composite types to register. In order to be able to (de)serialize specific composite types, you need to register them.

Instances

Eq ConnectionSettings Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Connection Methods (==) :: ConnectionSettings -> ConnectionSettings -> Bool # (/=) :: ConnectionSettings -> ConnectionSettings -> Bool #
Ord ConnectionSettings Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Connection Methods compare :: ConnectionSettings -> ConnectionSettings -> Ordering # (<) :: ConnectionSettings -> ConnectionSettings -> Bool # (<=) :: ConnectionSettings -> ConnectionSettings -> Bool # (>) :: ConnectionSettings -> ConnectionSettings -> Bool # (>=) :: ConnectionSettings -> ConnectionSettings -> Bool # max :: ConnectionSettings -> ConnectionSettings -> ConnectionSettings # min :: ConnectionSettings -> ConnectionSettings -> ConnectionSettings #
Show ConnectionSettings Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Connection Methods showsPrec :: Int -> ConnectionSettings -> ShowS # show :: ConnectionSettings -> String # showList :: [ConnectionSettings] -> ShowS #
Default ConnectionSettings Source #	Default connection settings. Note that all strings sent to PostgreSQL by the library are encoded as UTF-8, so don't alter client encoding unless you know what you're doing.
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Connection Methods def :: ConnectionSettings #

data ConnectionSourceM m Source #

Database connection supplier.

newtype ConnectionSource (cs :: [(* -> *) -> Constraint]) Source #

Wrapper for a polymorphic connection source.

Constructors

ConnectionSource
Fields unConnectionSource :: forall m. MkConstraint m cs => ConnectionSourceM m

simpleSource :: ConnectionSettings -> ConnectionSource [MonadBase IO, MonadMask] Source #

Default connection supplier. It establishes new database connection each time withConnection is called.

poolSource Source #

Arguments

:: ConnectionSettings
-> Int	Stripe count. The number of distinct sub-pools to maintain. The smallest acceptable value is 1.
-> NominalDiffTime	Amount of time for which an unused database connection is kept open. The smallest acceptable value is 0.5 seconds. The elapsed time before closing database connection may be a little longer than requested, as the reaper thread wakes at 1-second intervals.
-> Int	Maximum number of database connections to keep open per stripe. The smallest acceptable value is 1. Requests for database connections will block if this limit is reached on a single stripe, even if other stripes have idle connections available.
-> IO (ConnectionSource [MonadBase IO, MonadMask])

Pooled source. It uses striped pool from resource-pool package to cache established connections and reuse them.

Exceptions

data ErrorCode Source #

SQL error code. Reference: http://www.postgresql.org/docs/devel/static/errcodes-appendix.html.

Constructors

SuccessfulCompletion
Warning
DynamicResultSetsReturned
ImplicitZeroBitPadding
NullValueEliminatedInSetFunction
PrivilegeNotGranted
PrivilegeNotRevoked
StringDataRightTruncation_01
DeprecatedFeature
NoData
NoAdditionalDynamicResultSetsReturned
SqlStatementNotYetComplete
ConnectionException
ConnectionDoesNotExist
ConnectionFailure
SqlclientUnableToEstablishSqlconnection
SqlserverRejectedEstablishmentOfSqlconnection
TransactionResolutionUnknown
ProtocolViolation
TriggeredActionException
FeatureNotSupported
InvalidTransactionInitiation
LocatorException
InvalidLocatorSpecification
InvalidGrantor
InvalidGrantOperation
InvalidRoleSpecification
DiagnosticsException
StackedDiagnosticsAccessedWithoutActiveHandler
CaseNotFound
CardinalityViolation
DataException
ArraySubscriptError
CharacterNotInRepertoire
DatetimeFieldOverflow
DivisionByZero
ErrorInAssignment
EscapeCharacterConflict
IndicatorOverflow
IntervalFieldOverflow
InvalidArgumentForLogarithm
InvalidArgumentForNtileFunction
InvalidArgumentForNthValueFunction
InvalidArgumentForPowerFunction
InvalidArgumentForWidthBucketFunction
InvalidCharacterValueForCast
InvalidDatetimeFormat
InvalidEscapeCharacter
InvalidEscapeOctet
InvalidEscapeSequence
NonstandardUseOfEscapeCharacter
InvalidIndicatorParameterValue
InvalidParameterValue
InvalidRegularExpression
InvalidRowCountInLimitClause
InvalidRowCountInResultOffsetClause
InvalidTimeZoneDisplacementValue
InvalidUseOfEscapeCharacter
MostSpecificTypeMismatch
NullValueNotAllowed_22
NullValueNoIndicatorParameter
NumericValueOutOfRange
StringDataLengthMismatch
StringDataRightTruncation_22
SubstringError
TrimError
UnterminatedCString
ZeroLengthCharacterString
FloatingPointException
InvalidTextRepresentation
InvalidBinaryRepresentation
BadCopyFileFormat
UntranslatableCharacter
NotAnXmlDocument
InvalidXmlDocument
InvalidXmlContent
InvalidXmlComment
InvalidXmlProcessingInstruction
IntegrityConstraintViolation
RestrictViolation
NotNullViolation
ForeignKeyViolation
UniqueViolation
CheckViolation
ExclusionViolation
InvalidCursorState
InvalidTransactionState
ActiveSqlTransaction
BranchTransactionAlreadyActive
HeldCursorRequiresSameIsolationLevel
InappropriateAccessModeForBranchTransaction
InappropriateIsolationLevelForBranchTransaction
NoActiveSqlTransactionForBranchTransaction
ReadOnlySqlTransaction
SchemaAndDataStatementMixingNotSupported
NoActiveSqlTransaction
InFailedSqlTransaction
InvalidSqlStatementName
TriggeredDataChangeViolation
InvalidAuthorizationSpecification
InvalidPassword
DependentPrivilegeDescriptorsStillExist
DependentObjectsStillExist
InvalidTransactionTermination
SqlRoutineException
FunctionExecutedNoReturnStatement
ModifyingSqlDataNotPermitted_2F
ProhibitedSqlStatementAttempted_2F
ReadingSqlDataNotPermitted_2F
InvalidCursorName
ExternalRoutineException
ContainingSqlNotPermitted
ModifyingSqlDataNotPermitted_38
ProhibitedSqlStatementAttempted_38
ReadingSqlDataNotPermitted_38
ExternalRoutineInvocationException
InvalidSqlstateReturned
NullValueNotAllowed_39
TriggerProtocolViolated
SrfProtocolViolated
SavepointException
InvalidSavepointSpecification
InvalidCatalogName
InvalidSchemaName
TransactionRollback
TransactionIntegrityConstraintViolation
SerializationFailure
StatementCompletionUnknown
DeadlockDetected
SyntaxErrorOrAccessRuleViolation
SyntaxError
InsufficientPrivilege
CannotCoerce
GroupingError
WindowingError
InvalidRecursion
InvalidForeignKey
InvalidName
NameTooLong
ReservedName
DatatypeMismatch
IndeterminateDatatype
CollationMismatch
IndeterminateCollation
WrongObjectType
UndefinedColumn
UndefinedFunction
UndefinedTable
UndefinedParameter
UndefinedObject
DuplicateColumn
DuplicateCursor
DuplicateDatabase
DuplicateFunction
DuplicatePreparedStatement
DuplicateSchema
DuplicateTable
DuplicateAlias
DuplicateObject
AmbiguousColumn
AmbiguousFunction
AmbiguousParameter
AmbiguousAlias
InvalidColumnReference
InvalidColumnDefinition
InvalidCursorDefinition
InvalidDatabaseDefinition
InvalidFunctionDefinition
InvalidPreparedStatementDefinition
InvalidSchemaDefinition
InvalidTableDefinition
InvalidObjectDefinition
WithCheckOptionViolation
InsufficientResources
DiskFull
OutOfMemory
TooManyConnections
ConfigurationLimitExceeded
ProgramLimitExceeded
StatementTooComplex
TooManyColumns
TooManyArguments
ObjectNotInPrerequisiteState
ObjectInUse
CantChangeRuntimeParam
LockNotAvailable
OperatorIntervention
QueryCanceled
AdminShutdown
CrashShutdown
CannotConnectNow
DatabaseDropped
SystemError
IoError
UndefinedFile
DuplicateFile
ConfigFileError
LockFileExists
FdwError
FdwColumnNameNotFound
FdwDynamicParameterValueNeeded
FdwFunctionSequenceError
FdwInconsistentDescriptorInformation
FdwInvalidAttributeValue
FdwInvalidColumnName
FdwInvalidColumnNumber
FdwInvalidDataType
FdwInvalidDataTypeDescriptors
FdwInvalidDescriptorFieldIdentifier
FdwInvalidHandle
FdwInvalidOptionIndex
FdwInvalidOptionName
FdwInvalidStringLengthOrBufferLength
FdwInvalidStringFormat
FdwInvalidUseOfNullPointer
FdwTooManyHandles
FdwOutOfMemory
FdwNoSchemas
FdwOptionNameNotFound
FdwReplyHandle
FdwSchemaNotFound
FdwTableNotFound
FdwUnableToCreateExecution
FdwUnableToCreateReply
FdwUnableToEstablishConnection
PlpgsqlError
RaiseException
NoDataFound
TooManyRows
InternalError
DataCorrupted
IndexCorrupted
UnknownErrorCode String

Instances

Eq ErrorCode Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error.Code Methods (==) :: ErrorCode -> ErrorCode -> Bool # (/=) :: ErrorCode -> ErrorCode -> Bool #
Ord ErrorCode Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error.Code Methods compare :: ErrorCode -> ErrorCode -> Ordering # (<) :: ErrorCode -> ErrorCode -> Bool # (<=) :: ErrorCode -> ErrorCode -> Bool # (>) :: ErrorCode -> ErrorCode -> Bool # (>=) :: ErrorCode -> ErrorCode -> Bool # max :: ErrorCode -> ErrorCode -> ErrorCode # min :: ErrorCode -> ErrorCode -> ErrorCode #
Show ErrorCode Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error.Code Methods showsPrec :: Int -> ErrorCode -> ShowS # show :: ErrorCode -> String # showList :: [ErrorCode] -> ShowS #

data DetailedQueryError Source #

SQL query error. Reference: description of PQresultErrorField at http://www.postgresql.org/docs/devel/static/libpq-exec.html.

Constructors

DetailedQueryError
Fields qeSeverity :: !String qeErrorCode :: !ErrorCode qeMessagePrimary :: !String qeMessageDetail :: !(Maybe String) qeMessageHint :: !(Maybe String) qeStatementPosition :: !(Maybe Int) qeInternalPosition :: !(Maybe Int) qeInternalQuery :: !(Maybe String) qeContext :: !(Maybe String) qeSourceFile :: !(Maybe String) qeSourceLine :: !(Maybe Int) qeSourceFunction :: !(Maybe String)

Instances

Eq DetailedQueryError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods (==) :: DetailedQueryError -> DetailedQueryError -> Bool # (/=) :: DetailedQueryError -> DetailedQueryError -> Bool #
Ord DetailedQueryError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods compare :: DetailedQueryError -> DetailedQueryError -> Ordering # (<) :: DetailedQueryError -> DetailedQueryError -> Bool # (<=) :: DetailedQueryError -> DetailedQueryError -> Bool # (>) :: DetailedQueryError -> DetailedQueryError -> Bool # (>=) :: DetailedQueryError -> DetailedQueryError -> Bool # max :: DetailedQueryError -> DetailedQueryError -> DetailedQueryError # min :: DetailedQueryError -> DetailedQueryError -> DetailedQueryError #
Show DetailedQueryError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods showsPrec :: Int -> DetailedQueryError -> ShowS # show :: DetailedQueryError -> String # showList :: [DetailedQueryError] -> ShowS #
Exception DetailedQueryError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods toException :: DetailedQueryError -> SomeException # fromException :: SomeException -> Maybe DetailedQueryError # displayException :: DetailedQueryError -> String #

newtype QueryError Source #

Simple SQL query error. Thrown when there is no PGresult object corresponding to query execution.

Constructors

QueryError String

Instances

Eq QueryError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods (==) :: QueryError -> QueryError -> Bool # (/=) :: QueryError -> QueryError -> Bool #
Ord QueryError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods compare :: QueryError -> QueryError -> Ordering # (<) :: QueryError -> QueryError -> Bool # (<=) :: QueryError -> QueryError -> Bool # (>) :: QueryError -> QueryError -> Bool # (>=) :: QueryError -> QueryError -> Bool # max :: QueryError -> QueryError -> QueryError # min :: QueryError -> QueryError -> QueryError #
Show QueryError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods showsPrec :: Int -> QueryError -> ShowS # show :: QueryError -> String # showList :: [QueryError] -> ShowS #
Exception QueryError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods toException :: QueryError -> SomeException # fromException :: SomeException -> Maybe QueryError # displayException :: QueryError -> String #

newtype HPQTypesError Source #

Internal error in this library.

Constructors

HPQTypesError String

Instances

Eq HPQTypesError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods (==) :: HPQTypesError -> HPQTypesError -> Bool # (/=) :: HPQTypesError -> HPQTypesError -> Bool #
Ord HPQTypesError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods compare :: HPQTypesError -> HPQTypesError -> Ordering # (<) :: HPQTypesError -> HPQTypesError -> Bool # (<=) :: HPQTypesError -> HPQTypesError -> Bool # (>) :: HPQTypesError -> HPQTypesError -> Bool # (>=) :: HPQTypesError -> HPQTypesError -> Bool # max :: HPQTypesError -> HPQTypesError -> HPQTypesError # min :: HPQTypesError -> HPQTypesError -> HPQTypesError #
Show HPQTypesError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods showsPrec :: Int -> HPQTypesError -> ShowS # show :: HPQTypesError -> String # showList :: [HPQTypesError] -> ShowS #
Exception HPQTypesError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods toException :: HPQTypesError -> SomeException # fromException :: SomeException -> Maybe HPQTypesError # displayException :: HPQTypesError -> String #

newtype LibPQError Source #

Internal error in libpq/libpqtypes library.

Constructors

LibPQError String

Instances

Eq LibPQError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods (==) :: LibPQError -> LibPQError -> Bool # (/=) :: LibPQError -> LibPQError -> Bool #
Ord LibPQError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods compare :: LibPQError -> LibPQError -> Ordering # (<) :: LibPQError -> LibPQError -> Bool # (<=) :: LibPQError -> LibPQError -> Bool # (>) :: LibPQError -> LibPQError -> Bool # (>=) :: LibPQError -> LibPQError -> Bool # max :: LibPQError -> LibPQError -> LibPQError # min :: LibPQError -> LibPQError -> LibPQError #
Show LibPQError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods showsPrec :: Int -> LibPQError -> ShowS # show :: LibPQError -> String # showList :: [LibPQError] -> ShowS #
Exception LibPQError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods toException :: LibPQError -> SomeException # fromException :: SomeException -> Maybe LibPQError # displayException :: LibPQError -> String #

data ConversionError Source #

Data conversion error. Since it's polymorphic in error type, it nicely reports arbitrarily nested conversion errors.

Constructors

Exception e => ConversionError
Fields convColumn :: !Int Column number (Starts with 1). convColumnName :: !String Name of the column. convRow :: !Int Row number (Starts with 1). convError :: !e Exact error.

Instances

Show ConversionError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods showsPrec :: Int -> ConversionError -> ShowS # show :: ConversionError -> String # showList :: [ConversionError] -> ShowS #
Exception ConversionError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods toException :: ConversionError -> SomeException # fromException :: SomeException -> Maybe ConversionError # displayException :: ConversionError -> String #

data ArrayItemError Source #

Array item error. Polymorphic in error type for the same reason as ConversionError.

Constructors

Exception e => ArrayItemError
Fields arrItemIndex :: !Int Item index (Starts with 1). arrItemError :: !e Exact error.

Instances

Show ArrayItemError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods showsPrec :: Int -> ArrayItemError -> ShowS # show :: ArrayItemError -> String # showList :: [ArrayItemError] -> ShowS #
Exception ArrayItemError Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods toException :: ArrayItemError -> SomeException # fromException :: SomeException -> Maybe ArrayItemError # displayException :: ArrayItemError -> String #

data InvalidValue t Source #

"Invalid value" error for various data types.

Constructors

InvalidValue
Fields ivValue :: t Invalid value. ivValidValues :: Maybe [t]

Instances

Eq t => Eq (InvalidValue t) Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods (==) :: InvalidValue t -> InvalidValue t -> Bool # (/=) :: InvalidValue t -> InvalidValue t -> Bool #
Ord t => Ord (InvalidValue t) Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods compare :: InvalidValue t -> InvalidValue t -> Ordering # (<) :: InvalidValue t -> InvalidValue t -> Bool # (<=) :: InvalidValue t -> InvalidValue t -> Bool # (>) :: InvalidValue t -> InvalidValue t -> Bool # (>=) :: InvalidValue t -> InvalidValue t -> Bool # max :: InvalidValue t -> InvalidValue t -> InvalidValue t # min :: InvalidValue t -> InvalidValue t -> InvalidValue t #
Show t => Show (InvalidValue t) Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods showsPrec :: Int -> InvalidValue t -> ShowS # show :: InvalidValue t -> String # showList :: [InvalidValue t] -> ShowS #
(Show t, Typeable t) => Exception (InvalidValue t) Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods toException :: InvalidValue t -> SomeException # fromException :: SomeException -> Maybe (InvalidValue t) # displayException :: InvalidValue t -> String #

data RangeError t Source #

Range error for various data types.

Constructors

RangeError
Fields reRange :: [(t, t)] Allowed range (sum of acceptable ranges). reValue :: t Provided value which is not in above range.

Instances

Eq t => Eq (RangeError t) Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods (==) :: RangeError t -> RangeError t -> Bool # (/=) :: RangeError t -> RangeError t -> Bool #
Ord t => Ord (RangeError t) Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods compare :: RangeError t -> RangeError t -> Ordering # (<) :: RangeError t -> RangeError t -> Bool # (<=) :: RangeError t -> RangeError t -> Bool # (>) :: RangeError t -> RangeError t -> Bool # (>=) :: RangeError t -> RangeError t -> Bool # max :: RangeError t -> RangeError t -> RangeError t # min :: RangeError t -> RangeError t -> RangeError t #
Show t => Show (RangeError t) Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods showsPrec :: Int -> RangeError t -> ShowS # show :: RangeError t -> String # showList :: [RangeError t] -> ShowS #
(Show t, Typeable t) => Exception (RangeError t) Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods toException :: RangeError t -> SomeException # fromException :: SomeException -> Maybe (RangeError t) # displayException :: RangeError t -> String #

data ArrayDimensionMismatch Source #

Array dimenstion mismatch error.

Constructors

ArrayDimensionMismatch
Fields arrDimExpected :: !Int Dimension expected by the library. arrDimDelivered :: !Int Dimension provided by the database.

Instances

Eq ArrayDimensionMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods (==) :: ArrayDimensionMismatch -> ArrayDimensionMismatch -> Bool # (/=) :: ArrayDimensionMismatch -> ArrayDimensionMismatch -> Bool #
Ord ArrayDimensionMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods compare :: ArrayDimensionMismatch -> ArrayDimensionMismatch -> Ordering # (<) :: ArrayDimensionMismatch -> ArrayDimensionMismatch -> Bool # (<=) :: ArrayDimensionMismatch -> ArrayDimensionMismatch -> Bool # (>) :: ArrayDimensionMismatch -> ArrayDimensionMismatch -> Bool # (>=) :: ArrayDimensionMismatch -> ArrayDimensionMismatch -> Bool # max :: ArrayDimensionMismatch -> ArrayDimensionMismatch -> ArrayDimensionMismatch # min :: ArrayDimensionMismatch -> ArrayDimensionMismatch -> ArrayDimensionMismatch #
Show ArrayDimensionMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods showsPrec :: Int -> ArrayDimensionMismatch -> ShowS # show :: ArrayDimensionMismatch -> String # showList :: [ArrayDimensionMismatch] -> ShowS #
Exception ArrayDimensionMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods toException :: ArrayDimensionMismatch -> SomeException # fromException :: SomeException -> Maybe ArrayDimensionMismatch # displayException :: ArrayDimensionMismatch -> String #

data RowLengthMismatch Source #

Row length mismatch error.

Constructors

RowLengthMismatch
Fields lengthExpected :: !Int Length expected by the library. lengthDelivered :: !Int Length delivered by the database.

Instances

Eq RowLengthMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods (==) :: RowLengthMismatch -> RowLengthMismatch -> Bool # (/=) :: RowLengthMismatch -> RowLengthMismatch -> Bool #
Ord RowLengthMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods compare :: RowLengthMismatch -> RowLengthMismatch -> Ordering # (<) :: RowLengthMismatch -> RowLengthMismatch -> Bool # (<=) :: RowLengthMismatch -> RowLengthMismatch -> Bool # (>) :: RowLengthMismatch -> RowLengthMismatch -> Bool # (>=) :: RowLengthMismatch -> RowLengthMismatch -> Bool # max :: RowLengthMismatch -> RowLengthMismatch -> RowLengthMismatch # min :: RowLengthMismatch -> RowLengthMismatch -> RowLengthMismatch #
Show RowLengthMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods showsPrec :: Int -> RowLengthMismatch -> ShowS # show :: RowLengthMismatch -> String # showList :: [RowLengthMismatch] -> ShowS #
Exception RowLengthMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods toException :: RowLengthMismatch -> SomeException # fromException :: SomeException -> Maybe RowLengthMismatch # displayException :: RowLengthMismatch -> String #

data AffectedRowsMismatch Source #

Affected/returned rows mismatch error.

Constructors

AffectedRowsMismatch
Fields rowsExpected :: ![(Int, Int)] Number of rows expected by the library, expressed as sum of acceptable ranges, eg. [(1,2), (5,10)] means that it would accept 1, 2, 5, 6, 7, 8, 9 or 10 affected/returned rows. rowsDelivered :: !Int Number of affected/returned rows by the database.

Instances

Eq AffectedRowsMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods (==) :: AffectedRowsMismatch -> AffectedRowsMismatch -> Bool # (/=) :: AffectedRowsMismatch -> AffectedRowsMismatch -> Bool #
Ord AffectedRowsMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods compare :: AffectedRowsMismatch -> AffectedRowsMismatch -> Ordering # (<) :: AffectedRowsMismatch -> AffectedRowsMismatch -> Bool # (<=) :: AffectedRowsMismatch -> AffectedRowsMismatch -> Bool # (>) :: AffectedRowsMismatch -> AffectedRowsMismatch -> Bool # (>=) :: AffectedRowsMismatch -> AffectedRowsMismatch -> Bool # max :: AffectedRowsMismatch -> AffectedRowsMismatch -> AffectedRowsMismatch # min :: AffectedRowsMismatch -> AffectedRowsMismatch -> AffectedRowsMismatch #
Show AffectedRowsMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods showsPrec :: Int -> AffectedRowsMismatch -> ShowS # show :: AffectedRowsMismatch -> String # showList :: [AffectedRowsMismatch] -> ShowS #
Exception AffectedRowsMismatch Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Error Methods toException :: AffectedRowsMismatch -> SomeException # fromException :: SomeException -> Maybe AffectedRowsMismatch # displayException :: AffectedRowsMismatch -> String #

data DBException Source #

Main exception type. All exceptions thrown by the library are additionally wrapped in this type.

Constructors

(Exception e, Show sql) => DBException
Fields dbeQueryContext :: !sql Last SQL query that was executed. dbeError :: !e Specific error.

Instances

Show DBException Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Exception Methods showsPrec :: Int -> DBException -> ShowS # show :: DBException -> String # showList :: [DBException] -> ShowS #
Exception DBException Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.Exception Methods toException :: DBException -> SomeException # fromException :: SomeException -> Maybe DBException # displayException :: DBException -> String #

Monad transformer

type DBT m = DBT_ m m Source #

runDBT :: (MonadBase IO m, MonadMask m) => ConnectionSourceM m -> TransactionSettings -> DBT m a -> m a Source #

Evaluate monadic action with supplied connection source and transaction settings.

mapDBT :: (DBState n -> DBState m) -> (m (a, DBState m) -> n (b, DBState n)) -> DBT m a -> DBT n b Source #

Transform the underlying monad.

Query result

data QueryResult t Source #

Representation of a query result. Provides Functor and Foldable instances for data transformation and extraction appropriately.

Instances

Functor QueryResult Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.QueryResult Methods fmap :: (a -> b) -> QueryResult a -> QueryResult b # (<$) :: a -> QueryResult b -> QueryResult a #
Foldable QueryResult Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Internal.QueryResult Methods fold :: Monoid m => QueryResult m -> m # foldMap :: Monoid m => (a -> m) -> QueryResult a -> m # foldr :: (a -> b -> b) -> b -> QueryResult a -> b # foldr' :: (a -> b -> b) -> b -> QueryResult a -> b # foldl :: (b -> a -> b) -> b -> QueryResult a -> b # foldl' :: (b -> a -> b) -> b -> QueryResult a -> b # foldr1 :: (a -> a -> a) -> QueryResult a -> a # foldl1 :: (a -> a -> a) -> QueryResult a -> a # toList :: QueryResult a -> [a] # null :: QueryResult a -> Bool # length :: QueryResult a -> Int # elem :: Eq a => a -> QueryResult a -> Bool # maximum :: Ord a => QueryResult a -> a # minimum :: Ord a => QueryResult a -> a # sum :: Num a => QueryResult a -> a # product :: Num a => QueryResult a -> a #