Safe Haskell	None
Language	Haskell2010

Database.PostgreSQL.PQTypes.Model.Check

Synopsis

data Check = Check {
- chkName :: RawSQL ()
- chkCondition :: RawSQL ()
- chkValidated :: Bool
}
tblCheck :: Check
sqlAddCheck :: Check -> RawSQL ()
sqlAddValidCheck :: Check -> RawSQL ()
sqlAddNotValidCheck :: Check -> RawSQL ()
sqlValidateCheck :: Check -> 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

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 #
Show Check Source #
Instance details Defined in Database.PostgreSQL.PQTypes.Model.Check Methods showsPrec :: Int -> Check -> ShowS # show :: Check -> String # showList :: [Check] -> ShowS #

tblCheck :: Check Source #

sqlAddCheck :: Check -> RawSQL () Source #

Deprecated: Use sqlAddValidCheck instead

Deprecated version of sqlAddValidCheck.

sqlAddValidCheck :: 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 :: Check -> RawSQL () Source #

Validate check previously created as NOT VALID.

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