| Safe Haskell | None |
|---|---|
| Language | Haskell2010 |
Database.PostgreSQL.PQTypes.Model.ForeignKey
Synopsis
- data ForeignKey = ForeignKey {
- fkColumns :: [RawSQL ()]
- fkRefTable :: RawSQL ()
- fkRefColumns :: [RawSQL ()]
- fkOnUpdate :: ForeignKeyAction
- fkOnDelete :: ForeignKeyAction
- fkDeferrable :: Bool
- fkDeferred :: Bool
- fkValidated :: Bool
- data ForeignKeyAction
- fkOnColumn :: RawSQL () -> RawSQL () -> RawSQL () -> ForeignKey
- fkOnColumns :: [RawSQL ()] -> RawSQL () -> [RawSQL ()] -> ForeignKey
- fkName :: RawSQL () -> ForeignKey -> RawSQL ()
- sqlAddFK :: RawSQL () -> ForeignKey -> RawSQL ()
- sqlAddValidFK :: RawSQL () -> ForeignKey -> RawSQL ()
- sqlAddNotValidFK :: RawSQL () -> ForeignKey -> RawSQL ()
- sqlValidateFK :: RawSQL () -> ForeignKey -> RawSQL ()
- sqlDropFK :: RawSQL () -> ForeignKey -> RawSQL ()
Documentation
data ForeignKey Source #
Constructors
| ForeignKey | |
Fields
| |
Instances
| Eq ForeignKey Source # | |
Defined in Database.PostgreSQL.PQTypes.Model.ForeignKey | |
| Ord ForeignKey Source # | |
Defined in Database.PostgreSQL.PQTypes.Model.ForeignKey Methods compare :: ForeignKey -> ForeignKey -> Ordering # (<) :: ForeignKey -> ForeignKey -> Bool # (<=) :: ForeignKey -> ForeignKey -> Bool # (>) :: ForeignKey -> ForeignKey -> Bool # (>=) :: ForeignKey -> ForeignKey -> Bool # max :: ForeignKey -> ForeignKey -> ForeignKey # min :: ForeignKey -> ForeignKey -> ForeignKey # | |
| Show ForeignKey Source # | |
Defined in Database.PostgreSQL.PQTypes.Model.ForeignKey Methods showsPrec :: Int -> ForeignKey -> ShowS # show :: ForeignKey -> String # showList :: [ForeignKey] -> ShowS # | |
data ForeignKeyAction Source #
Constructors
| ForeignKeyNoAction | |
| ForeignKeyRestrict | |
| ForeignKeyCascade | |
| ForeignKeySetNull | |
| ForeignKeySetDefault |
Instances
| Eq ForeignKeyAction Source # | |
Defined in Database.PostgreSQL.PQTypes.Model.ForeignKey Methods (==) :: ForeignKeyAction -> ForeignKeyAction -> Bool # (/=) :: ForeignKeyAction -> ForeignKeyAction -> Bool # | |
| Ord ForeignKeyAction Source # | |
Defined in Database.PostgreSQL.PQTypes.Model.ForeignKey Methods compare :: ForeignKeyAction -> ForeignKeyAction -> Ordering # (<) :: ForeignKeyAction -> ForeignKeyAction -> Bool # (<=) :: ForeignKeyAction -> ForeignKeyAction -> Bool # (>) :: ForeignKeyAction -> ForeignKeyAction -> Bool # (>=) :: ForeignKeyAction -> ForeignKeyAction -> Bool # max :: ForeignKeyAction -> ForeignKeyAction -> ForeignKeyAction # min :: ForeignKeyAction -> ForeignKeyAction -> ForeignKeyAction # | |
| Show ForeignKeyAction Source # | |
Defined in Database.PostgreSQL.PQTypes.Model.ForeignKey Methods showsPrec :: Int -> ForeignKeyAction -> ShowS # show :: ForeignKeyAction -> String # showList :: [ForeignKeyAction] -> ShowS # | |
fkOnColumn :: RawSQL () -> RawSQL () -> RawSQL () -> ForeignKey Source #
fkOnColumns :: [RawSQL ()] -> RawSQL () -> [RawSQL ()] -> ForeignKey Source #
sqlAddFK :: RawSQL () -> ForeignKey -> RawSQL () Source #
Deprecated: Use sqlAddValidFK instead
Deprecated version of sqlAddValidFK.
sqlAddValidFK :: RawSQL () -> ForeignKey -> RawSQL () Source #
Add valid foreign key. Warning: PostgreSQL acquires SHARE ROW EXCLUSIVE
lock (that prevents data updates) on both modified and referenced table for
the duration of the creation. If this is not acceptable, use
sqlAddNotValidFK and sqlValidateFK.
sqlAddNotValidFK :: RawSQL () -> ForeignKey -> RawSQL () Source #
Add foreign key marked as NOT VALID. This avoids potentially long
validation blocking updates to both modified and referenced table for its
duration. However, keys created as such need to be validated later using
sqlValidateFK.
sqlValidateFK :: RawSQL () -> ForeignKey -> RawSQL () Source #
Validate foreign key previously created as NOT VALID.