hpqtypes-extras-1.9.0.1: Extra utilities for hpqtypes library

Safe HaskellNone
LanguageHaskell2010

Database.PostgreSQL.PQTypes.Model.Check

Synopsis

Documentation

data Check Source #

Constructors

Check 

Fields

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 #

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.