Safe Haskell	Safe-Inferred
Language	Haskell2010

Database.PostgreSQL.PQTypes.Model.Check

Synopsis

data Check = Check {
- chkName :: RawSQL ()
- chkCondition :: RawSQL ()
- chkValidated :: Bool
}
tblCheck :: Check
sqlAddValidCheckMaybeDowntime :: Check -> RawSQL ()
sqlAddNotValidCheck :: Check -> RawSQL ()
sqlValidateCheck :: RawSQL () -> RawSQL ()
sqlDropCheck :: RawSQL () -> RawSQL ()

Documentation

data Check Source #

Constructors

Check
Fields chkName :: RawSQL () chkCondition :: RawSQL () chkValidated :: Bool Set to `False` if check is created as NOT VALID and left in such state (for whatever reason).

Instances

Instances details

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

tblCheck :: Check Source #

sqlAddValidCheckMaybeDowntime :: Check -> RawSQL () Source #

Add valid check constraint. Warning: PostgreSQL acquires SHARE ROW EXCLUSIVE lock (that prevents updates) on modified table for the duration of the creation. If this is not acceptable, use sqlAddNotValidCheck and sqlValidateCheck.

sqlAddNotValidCheck :: Check -> RawSQL () Source #

Add check marked as NOT VALID. This avoids potentially long validation blocking updates to modified table for its duration. However, checks created as such need to be validated later using sqlValidateCheck.

sqlValidateCheck :: RawSQL () -> RawSQL () Source #

Validate check previously created as NOT VALID.

sqlDropCheck :: RawSQL () -> RawSQL () Source #