hpqtypes-extras-1.15.0.0: Extra utilities for hpqtypes library
Safe HaskellNone
LanguageHaskell2010

Database.PostgreSQL.PQTypes.Model.Index

Synopsis

Documentation

data TableIndex Source #

Constructors

TableIndex 

Fields

indexOnColumnWithMethod :: IndexColumn -> IndexMethod -> TableIndex Source #

Create an index on the given column with the specified method. No checks are made that the method is appropriate for the type of the column.

indexOnColumnsWithMethod :: [IndexColumn] -> IndexMethod -> TableIndex Source #

Create an index on the given columns with the specified method. No checks are made that the method is appropriate for the type of the column; cf. the PostgreSQL manual.

sqlCreateIndexMaybeDowntime :: RawSQL () -> TableIndex -> RawSQL () Source #

Create an index. Warning: if the affected table is large, this will prevent the table from being modified during the creation. If this is not acceptable, use CreateIndexConcurrentlyMigration. See https://www.postgresql.org/docs/current/sql-createindex.html for more information.

sqlCreateIndexConcurrently :: RawSQL () -> TableIndex -> RawSQL () Source #

Create index concurrently.

sqlDropIndexMaybeDowntime :: RawSQL () -> TableIndex -> RawSQL () Source #

Drop an index. Warning: if you don't want to lock out concurrent operations on the index's table, use DropIndexConcurrentlyMigration. See https://www.postgresql.org/docs/current/sql-dropindex.html for more information.