hpqtypes-extras-1.16.4.3: Extra utilities for hpqtypes library
Safe HaskellSafe-Inferred
LanguageHaskell2010

Database.PostgreSQL.PQTypes.Model.Check

Synopsis

Documentation

data Check Source #

Constructors

Check 

Fields

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 #

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.