Database.PostgreSQL.PQTypes.Model.Check

Documentation

data Check

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

Show Check

Defined in Database.PostgreSQL.PQTypes.Model.Check

Methods

showsPrec :: Int -> Check -> ShowS

show :: Check -> String

showList :: [Check] -> ShowS

Eq Check

Defined in Database.PostgreSQL.PQTypes.Model.Check

Methods

(==) :: Check -> Check -> Bool

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

Ord Check

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

sqlAddValidCheckMaybeDowntime :: Check -> RawSQL ()

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 ()

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 ()

Validate check previously created as NOT VALID.

sqlDropCheck :: RawSQL () -> RawSQL ()