DialectPostgreSQL (Nuxeo ECM Projects 7.2-SNAPSHOT API)

java.lang.Object
- org.nuxeo.ecm.core.storage.sql.jdbc.dialect.Dialect
- - org.nuxeo.ecm.core.storage.sql.jdbc.dialect.DialectPostgreSQL

```
public class DialectPostgreSQL
extends Dialect
```
PostgreSQL-specific dialect.

Author:

Florent Guillaume

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

static class DialectPostgreSQL.ArraySubQueryPostgreSQL
- Nested classes/interfaces inherited from class org.nuxeo.ecm.core.storage.sql.jdbc.dialect.Dialect
  Dialect.ArraySubQuery, Dialect.DialectIdType, Dialect.FulltextMatchInfo, Dialect.JDBCInfo

Nested Classes
Modifier and Type	Class and Description
`static class`	`DialectPostgreSQL.ArraySubQueryPostgreSQL`

Field Summary
- Fields inherited from class org.nuxeo.ecm.core.storage.sql.jdbc.dialect.Dialect
  ARRAY_SEP, DEBUG_REAL_UUIDS, DEBUG_UUIDS, DIALECT_CLASS, DIALECTS, NULLS_LAST_ON_DESC_PROP

Constructor Summary

Constructors
Constructor and Description

DialectPostgreSQL(DatabaseMetaData metadata, RepositoryDescriptor repositoryDescriptor)

Constructors
Constructor and Description
`DialectPostgreSQL(DatabaseMetaData metadata, RepositoryDescriptor repositoryDescriptor)`

Method Summary

Methods
Modifier and Type	Method and Description
`String`	`addPagingClause(String sql, long limit, long offset)` Returns the SQL query with a paging clause
`String`	`castIdToVarchar(String expr)` Casts an id column to a VARCHAR type.
`Array`	`createArrayOf(int type, Object[] elements, Connection connection)` Factory method for creating Array objects, suitable for passing to `PreparedStatement.setArray(int, java.sql.Array)`.
`boolean`	`doesUpdateFromRepeatSelf()` When doing an UPDATE t SET ...
`void`	`existingTableDetected(Connection connection, Table table, Model model, Database database)` Called after an existing table has been detected in the database.
`String`	`getAncestorsIdsSql()` Gets the SQL query to get the ancestors of a set of ids.
`String`	`getArrayElementString(String arrayColumnName, int arrayElementIndex)` Get SQL Array Element Subscripted string.
`String`	`getArrayIlikeSql(Column arrayColumn, String refName, boolean positive, Table dataHierTable)` Gets the SQL string for an array column ILIKE expression.
`String`	`getArrayInSql(Column arrayColumn, String cast, boolean positive, List<Serializable> params)` Gets the SQL string for an array column IN expression.
`String`	`getArrayLikeSql(Column arrayColumn, String refName, boolean positive, Table dataHierTable)` Gets the SQL string for an array column LIKE expression.
`Dialect.ArraySubQuery`	`getArraySubQuery(Column arrayColumn, String subQueryAlias)` Gets the dialect-specific subquery for an array column.
`String`	`getBinaryFulltextSql(List<String> columns)` Return the SQL to get the columns fulltext fields
`String`	`getCascadeDropConstraintsString()`
`String`	`getClusterGetInvalidations()` Gets the SQL to query invalidations for this cluster node.
`String`	`getClusterInsertInvalidations()` Gets the SQL to send an invalidation to the cluster.
`String`	`getColumnName(String name)`
`String`	`getCreateFulltextIndexSql(String indexName, String quotedIndexName, Table table, List<Column> columns, Model model)` Gets a CREATE INDEX statement for a fulltext index.
`String`	`getDateCast()` Get the expression to use to cast a column to a DATE type.
`String`	`getDialectFulltextQuery(String query)` Get the dialect-specific version of a fulltext query.
`String`	`getFreeVariableSetterForType(ColumnType type)` Gets the JDBC expression setting a free value for this column type.
`Serializable`	`getFromResultSet(ResultSet rs, int index, Column column)`
`int`	`getFulltextIndexedColumns()` Specifies what columns of the fulltext table have to be indexed.
`Dialect.FulltextMatchInfo`	`getFulltextScoredMatchInfo(String fulltextQuery, String indexName, int nthMatch, Column mainColumn, Model model, Database database)` Gets the SQL information needed to do a a fulltext match, either with a direct expression in the WHERE clause, or using a join with an additional table.
`Serializable`	`getGeneratedId(Connection connection)` Gets a generated id if so configured, otherwise returns null.
`Serializable`	`getId(ResultSet rs, int index)`
`Dialect.DialectIdType`	`getIdType()` Gets the type of id when stored in the database.
`String`	`getInTreeSql(String idColumnName)` Gets the expression to use to check tree membership.
`Dialect.JDBCInfo`	`getJDBCTypeAndString(ColumnType type)` Gets the JDBC type and string from Nuxeo's type abstraction.
`String`	`getMatchMixinType(Column mixinsColumn, String mixin, boolean positive, String[] returnParam)` Gets the SQL fragment to match a mixin type.
`boolean`	`getMaterializeFulltextSyntheticColumn()` Does the fulltext synthetic column have to be materialized.
`String`	`getNoColumnsInsertString()`
`List<String>`	`getPostCreateTableSqls(Table table, Model model, Database database)` Gets the sql statements to call after a table has been created.
`String`	`getPrepareUserReadAclsSql()` Gets the SQL expression to prepare the user read acls cache.
`String`	`getReadAclsCheckSql(String userIdCol)` Gets the expression to check if access is allowed using read acls.
`String`	`getRebuildReadAclsSql()` Gets the statement to rebuild the wall read acls
`String`	`getSecurityCheckSql(String idColumnName)` Gets the expression to use to check security.
`String`	`getSoftDeleteCleanupSql()` SQL to clean soft-delete documents.
`String`	`getSoftDeleteSql()` SQL to soft delete documents.
`String`	`getSQLStatementsFilename()` Gets the name of the file containing the SQL statements.
`Map<String,Serializable>`	`getSQLStatementsProperties(Model model, Database database)` Gets the properties to use with the SQL statements.
`String`	`getTestSQLStatementsFilename()`
`String`	`getUpdateReadAclsSql()` Gets the statement to update the read acls
`String`	`getUsersSeparator()`
`String`	`getValidationQuery()` A query that, when executed, will make at least a round-trip to the server to check that the connection is alive.
`boolean`	`isAllowedConversion(int expected, int actual, String actualName, int actualSize)` Check mismatches between expected and actual JDBC types read from database introspection.
`boolean`	`isClusteringSupported()` Checks that clustering is supported.
`boolean`	`isConcurrentUpdateException(Throwable t)` Checks if an exception received means that a concurrent update was detected.
`boolean`	`isConnectionClosedException(Throwable t)` Checks if an exception received means that the low level connection has been trashed and must be reset.
`boolean`	`needsAliasForDerivedTable()` Whether a derived table (subselect in a FROM statement) needs an alias.
`boolean`	`needsNullsLastOnDescSort()` True if the dialect need an extra NULLS LAST on DESC sort.
`void`	`performAdditionalStatements(Connection connection)` Let the dialect processes additional statements after tables creation and conditional statements.
`boolean`	`preCreateTable(Connection connection, Table table, Model model, Database database)` Called before a table is created, when it's been determined that it doesn't exist yet.
`void`	`setId(PreparedStatement ps, int index, Serializable value)` Sets a prepared statement value that is a Nuxeo main id (usually UUID).
`void`	`setToPreparedStatement(PreparedStatement ps, int index, Serializable value, Column column)`
`boolean`	`supportsAncestorsTable()` Checks if the dialect supports an ancestors table.
`boolean`	`supportsArrayColumns()` Does the dialect support storing arrays in table columns.
`boolean`	`supportsArrays()` Does the dialect support passing ARRAY values (to stored procedures mostly).
`boolean`	`supportsIlike()` Does the dialect support ILIKE operator
`boolean`	`supportsPaging()` Indicates if dialect supports paging
`boolean`	`supportsReadAcl()` Does the dialect support an optimized read security checks
`boolean`	`supportsSysNameArray()` Checks if the dialect supports storing arrays of system names (for mixins for instance).
`boolean`	`supportsUpdateFrom()` Does the dialect support UPDATE t SET ...
`boolean`	`supportsWith()` Does the dialect support SQL-99 WITH common table expressions.
`String`	`toBooleanValueString(boolean bool)`

Methods inherited from class org.nuxeo.ecm.core.storage.sql.jdbc.dialect.Dialect
closeQuote, createDialect, getAddColumnString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getArrayResult, getBlobLengthFunction, getCalendarFromTimestamp, getCalendarFromTimestamp, getClobCast, getClusterDeleteInvalidations, getClusterNodeIdSql, getConnectionSchema, getCreateIndexSql, getCustomColumnDefinition, getCustomPostCreateSqls, getDescending, getForeignKeyConstraintName, getFulltextType, getIdentityGeneratedKeySql, getIgnoredColumns, getIndexName, getMaximumArgsForIn, getNullColumnString, getPostCreateIdentityColumnSql, getPrimaryKeyConstraintName, getTableName, getTableTypeString, getTimestampFromCalendar, getTimestampFromCalendar, hasIdentityGeneratedKey, hasNullEmptyString, isClusteringDeleteNeeded, isIdentityAlreadyPrimary, jdbcInfo, jdbcInfo, jdbcInfo, jdbcInfo, needsOracleJoins, needsOrderByKeysAfterDistinct, needsOriginalColumnInGroupBy, needsPrepareUserReadAcls, openQuote, performPostOpenStatements, qualifyIndexName, setIdLong, setToPreparedStatementTimestamp, storesUpperCaseIdentifiers, supportsArraysReturnInsteadOfRows, supportsCircularCascadeDeleteConstraints, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsMultipleFulltextIndexes, toHexString

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - DialectPostgreSQL
```
public DialectPostgreSQL(DatabaseMetaData metadata,
                 RepositoryDescriptor repositoryDescriptor)
                  throws StorageException
```
    Throws:
    
    StorageException
- Method Detail
  - toBooleanValueString
```
public String toBooleanValueString(boolean bool)
```
    Overrides:
    
    toBooleanValueString in class Dialect
  - getNoColumnsInsertString
```
public String getNoColumnsInsertString()
```
    Overrides:
    
    getNoColumnsInsertString in class Dialect
  - getCascadeDropConstraintsString
```
public String getCascadeDropConstraintsString()
```
    Overrides:
    
    getCascadeDropConstraintsString in class Dialect
  - getJDBCTypeAndString
```
public Dialect.JDBCInfo getJDBCTypeAndString(ColumnType type)
```
    Description copied from class: Dialect
    
    Gets the JDBC type and string from Nuxeo's type abstraction.
    
    Specified by:
    
    getJDBCTypeAndString in class Dialect
  - isAllowedConversion
```
public boolean isAllowedConversion(int expected,
                          int actual,
                          String actualName,
                          int actualSize)
```
    Description copied from class: Dialect
    
    Check mismatches between expected and actual JDBC types read from database introspection.
    
    Overrides:
    
    isAllowedConversion in class Dialect
  - getGeneratedId
```
public Serializable getGeneratedId(Connection connection)
                            throws SQLException
```
    Description copied from class: Dialect
    
    Gets a generated id if so configured, otherwise returns null.
    
    Overrides:
    
    getGeneratedId in class Dialect
    
    Throws:
    
    SQLException
  - setId
```
public void setId(PreparedStatement ps,
         int index,
         Serializable value)
           throws SQLException
```
    Description copied from class: Dialect
    
    Sets a prepared statement value that is a Nuxeo main id (usually UUID).
    
    Overrides:
    
    setId in class Dialect
    
    Parameters:
    ps - the prepared statement
    index - the parameter index in the prepared statement
    value - the value to set
    
    Throws:
    
    SQLException
  - getId
```
public Serializable getId(ResultSet rs,
                 int index)
                   throws SQLException
```
    Throws:
    
    SQLException
  - setToPreparedStatement
```
public void setToPreparedStatement(PreparedStatement ps,
                          int index,
                          Serializable value,
                          Column column)
                            throws SQLException
```
    Specified by:
    
    setToPreparedStatement in class Dialect
    
    Throws:
    
    SQLException
  - getFromResultSet
```
public Serializable getFromResultSet(ResultSet rs,
                            int index,
                            Column column)
                              throws SQLException
```
    Specified by:
    
    getFromResultSet in class Dialect
    
    Throws:
    
    SQLException
  - getColumnName
```
public String getColumnName(String name)
```
    Overrides:
    
    getColumnName in class Dialect
  - getCreateFulltextIndexSql
```
public String getCreateFulltextIndexSql(String indexName,
                               String quotedIndexName,
                               Table table,
                               List<Column> columns,
                               Model model)
```
    Description copied from class: Dialect
    
    Gets a CREATE INDEX statement for a fulltext index.
    
    Specified by:
    
    getCreateFulltextIndexSql in class Dialect
  - getDialectFulltextQuery
```
public String getDialectFulltextQuery(String query)
```
    Get the dialect-specific version of a fulltext query.
    The result of this is passed to getFulltextScoredMatchInfo(java.lang.String, java.lang.String, int, org.nuxeo.ecm.core.storage.sql.jdbc.db.Column, org.nuxeo.ecm.core.storage.sql.Model, org.nuxeo.ecm.core.storage.sql.jdbc.db.Database).
    
    Specified by:
    
    getDialectFulltextQuery in class Dialect
    
    Parameters:
    query - the CMIS-syntax-based fulltext query string
    
    Returns:
    the dialect native fulltext query string
  - getFulltextScoredMatchInfo
```
public Dialect.FulltextMatchInfo getFulltextScoredMatchInfo(String fulltextQuery,
                                                   String indexName,
                                                   int nthMatch,
                                                   Column mainColumn,
                                                   Model model,
                                                   Database database)
```
    Description copied from class: Dialect
    
    Gets the SQL information needed to do a a fulltext match, either with a direct expression in the WHERE clause, or using a join with an additional table.
    
    Specified by:
    
    getFulltextScoredMatchInfo in class Dialect
  - getMaterializeFulltextSyntheticColumn
```
public boolean getMaterializeFulltextSyntheticColumn()
```
    Description copied from class: Dialect
    
    Does the fulltext synthetic column have to be materialized.
    
    Specified by:
    
    getMaterializeFulltextSyntheticColumn in class Dialect
  - getFulltextIndexedColumns
```
public int getFulltextIndexedColumns()
```
    Description copied from class: Dialect
    
    Specifies what columns of the fulltext table have to be indexed.
    
    Specified by:
    
    getFulltextIndexedColumns in class Dialect
    
    Returns:
    0 for none, 1 for the synthetic one, 2 for the individual ones
  - getFreeVariableSetterForType
```
public String getFreeVariableSetterForType(ColumnType type)
```
    Description copied from class: Dialect
    
    Gets the JDBC expression setting a free value for this column type.
    Needed for columns that need an expression around the value being set, usually for conversion (this is the case for PostgreSQL fulltext TSVECTOR columns for instance).
    
    Overrides:
    
    getFreeVariableSetterForType in class Dialect
    
    Parameters:
    type - the column type
    
    Returns:
    the expression containing a free variable
  - supportsUpdateFrom
```
public boolean supportsUpdateFrom()
```
    Description copied from class: Dialect
    
    Does the dialect support UPDATE t SET ... FROM t, u WHERE ... ?
    
    Specified by:
    
    supportsUpdateFrom in class Dialect
  - doesUpdateFromRepeatSelf
```
public boolean doesUpdateFromRepeatSelf()
```
    Description copied from class: Dialect
    
    When doing an UPDATE t SET ... FROM t, u WHERE ..., does the FROM clause need to repeate the updated table (t).
    
    Specified by:
    
    doesUpdateFromRepeatSelf in class Dialect
  - needsAliasForDerivedTable
```
public boolean needsAliasForDerivedTable()
```
    Description copied from class: Dialect
    
    Whether a derived table (subselect in a FROM statement) needs an alias.
    
    Overrides:
    
    needsAliasForDerivedTable in class Dialect
  - supportsIlike
```
public boolean supportsIlike()
```
    Description copied from class: Dialect
    
    Does the dialect support ILIKE operator
    
    Overrides:
    
    supportsIlike in class Dialect
  - supportsReadAcl
```
public boolean supportsReadAcl()
```
    Description copied from class: Dialect
    
    Does the dialect support an optimized read security checks
    
    Overrides:
    
    supportsReadAcl in class Dialect
  - getPrepareUserReadAclsSql
```
public String getPrepareUserReadAclsSql()
```
    Description copied from class: Dialect
    
    Gets the SQL expression to prepare the user read acls cache. This can be used to populate a table cache.
    
    Overrides:
    
    getPrepareUserReadAclsSql in class Dialect
    
    Returns:
    and SQL expression with one parameter (principals)
  - getReadAclsCheckSql
```
public String getReadAclsCheckSql(String userIdCol)
```
    Description copied from class: Dialect
    
    Gets the expression to check if access is allowed using read acls. The dialect must suppportsReadAcl.
    
    Overrides:
    
    getReadAclsCheckSql in class Dialect
    
    Parameters:
    userIdCol - the quoted name of the aclr_user_map user_id column to use
    
    Returns:
    an SQL expression with one parameter (principals) that is true if access is allowed
  - getUpdateReadAclsSql
```
public String getUpdateReadAclsSql()
```
    Description copied from class: Dialect
    
    Gets the statement to update the read acls
    
    Overrides:
    
    getUpdateReadAclsSql in class Dialect
  - getRebuildReadAclsSql
```
public String getRebuildReadAclsSql()
```
    Description copied from class: Dialect
    
    Gets the statement to rebuild the wall read acls
    
    Overrides:
    
    getRebuildReadAclsSql in class Dialect
  - getSecurityCheckSql
```
public String getSecurityCheckSql(String idColumnName)
```
    Description copied from class: Dialect
    
    Gets the expression to use to check security.
    
    Specified by:
    
    getSecurityCheckSql in class Dialect
    
    Parameters:
    idColumnName - the quoted name of the id column to use
    
    Returns:
    an SQL expression with two parameters (principals and permissions) that is true if access is allowed
  - supportsAncestorsTable
```
public boolean supportsAncestorsTable()
```
    Description copied from class: Dialect
    
    Checks if the dialect supports an ancestors table.
    
    Overrides:
    
    supportsAncestorsTable in class Dialect
  - getInTreeSql
```
public String getInTreeSql(String idColumnName)
```
    Description copied from class: Dialect
    
    Gets the expression to use to check tree membership.
    
    Specified by:
    
    getInTreeSql in class Dialect
    
    Parameters:
    idColumnName - the quoted name of the id column to use
    
    Returns:
    an SQL expression with one parameters for the based id that is true if the document is under base id
  - getMatchMixinType
```
public String getMatchMixinType(Column mixinsColumn,
                       String mixin,
                       boolean positive,
                       String[] returnParam)
```
    Description copied from class: Dialect
    
    Gets the SQL fragment to match a mixin type.
    
    Overrides:
    
    getMatchMixinType in class Dialect
  - supportsSysNameArray
```
public boolean supportsSysNameArray()
```
    Description copied from class: Dialect
    
    Checks if the dialect supports storing arrays of system names (for mixins for instance).
    
    Overrides:
    
    supportsSysNameArray in class Dialect
  - supportsArrays
```
public boolean supportsArrays()
```
    Description copied from class: Dialect
    
    Does the dialect support passing ARRAY values (to stored procedures mostly).
    If not, we'll simulate them using a string and a separator.
    
    Overrides:
    
    supportsArrays in class Dialect
    
    Returns:
    true if ARRAY values are supported
  - supportsArrayColumns
```
public boolean supportsArrayColumns()
```
    Description copied from class: Dialect
    
    Does the dialect support storing arrays in table columns.
    
    Overrides:
    
    supportsArrayColumns in class Dialect
    
    Returns:
    true if ARRAY columns are supported
  - getArraySubQuery
```
public Dialect.ArraySubQuery getArraySubQuery(Column arrayColumn,
                                     String subQueryAlias)
                                       throws QueryMaker.QueryMakerException
```
    Description copied from class: Dialect
    
    Gets the dialect-specific subquery for an array column.
    
    Overrides:
    
    getArraySubQuery in class Dialect
    
    Throws:
    
    QueryMaker.QueryMakerException
  - getArrayElementString
```
public String getArrayElementString(String arrayColumnName,
                           int arrayElementIndex)
                             throws QueryMaker.QueryMakerException
```
    Description copied from class: Dialect
    
    Get SQL Array Element Subscripted string.
    
    Overrides:
    
    getArrayElementString in class Dialect
    
    Throws:
    
    QueryMaker.QueryMakerException
  - getArrayInSql
```
public String getArrayInSql(Column arrayColumn,
                   String cast,
                   boolean positive,
                   List<Serializable> params)
```
    Description copied from class: Dialect
    
    Gets the SQL string for an array column IN expression.
    
    Overrides:
    
    getArrayInSql in class Dialect
  - getArrayLikeSql
```
public String getArrayLikeSql(Column arrayColumn,
                     String refName,
                     boolean positive,
                     Table dataHierTable)
```
    Description copied from class: Dialect
    
    Gets the SQL string for an array column LIKE expression.
    
    Overrides:
    
    getArrayLikeSql in class Dialect
  - getArrayIlikeSql
```
public String getArrayIlikeSql(Column arrayColumn,
                      String refName,
                      boolean positive,
                      Table dataHierTable)
```
    Description copied from class: Dialect
    
    Gets the SQL string for an array column ILIKE expression.
    
    Overrides:
    
    getArrayIlikeSql in class Dialect
  - createArrayOf
```
public Array createArrayOf(int type,
                  Object[] elements,
                  Connection connection)
                    throws SQLException
```
    Description copied from class: Dialect
    
    Factory method for creating Array objects, suitable for passing to PreparedStatement.setArray(int, java.sql.Array).
    (An equivalent method is defined by JDBC4 on the Connection class.)
    
    Overrides:
    
    createArrayOf in class Dialect
    
    Parameters:
    type - the SQL type of the elements
    elements - the elements of the array
    connection - the connection
    
    Returns:
    an Array holding the elements
    
    Throws:
    
    SQLException
  - getSQLStatementsFilename
```
public String getSQLStatementsFilename()
```
    Description copied from class: Dialect
    
    Gets the name of the file containing the SQL statements.
    
    Specified by:
    
    getSQLStatementsFilename in class Dialect
  - getTestSQLStatementsFilename
```
public String getTestSQLStatementsFilename()
```
    Specified by:
    
    getTestSQLStatementsFilename in class Dialect
  - getSQLStatementsProperties
```
public Map<String,Serializable> getSQLStatementsProperties(Model model,
                                                  Database database)
```
    Description copied from class: Dialect
    
    Gets the properties to use with the SQL statements.
    
    Specified by:
    
    getSQLStatementsProperties in class Dialect
  - preCreateTable
```
public boolean preCreateTable(Connection connection,
                     Table table,
                     Model model,
                     Database database)
                       throws SQLException
```
    Description copied from class: Dialect
    
    Called before a table is created, when it's been determined that it doesn't exist yet.
    
    Overrides:
    
    preCreateTable in class Dialect
    
    Returns:
    false if the table must actually not be created
    
    Throws:
    
    SQLException
  - getPostCreateTableSqls
```
public List<String> getPostCreateTableSqls(Table table,
                                  Model model,
                                  Database database)
```
    Description copied from class: Dialect
    
    Gets the sql statements to call after a table has been created.
    Used for migrations/upgrades.
    
    Overrides:
    
    getPostCreateTableSqls in class Dialect
  - existingTableDetected
```
public void existingTableDetected(Connection connection,
                         Table table,
                         Model model,
                         Database database)
                           throws SQLException
```
    Description copied from class: Dialect
    
    Called after an existing table has been detected in the database.
    Used for migrations/upgrades.
    
    Overrides:
    
    existingTableDetected in class Dialect
    
    Throws:
    
    SQLException
  - isClusteringSupported
```
public boolean isClusteringSupported()
```
    Description copied from class: Dialect
    
    Checks that clustering is supported.
    
    Overrides:
    
    isClusteringSupported in class Dialect
  - getClusterInsertInvalidations
```
public String getClusterInsertInvalidations()
```
    Description copied from class: Dialect
    
    Gets the SQL to send an invalidation to the cluster.
    
    Overrides:
    
    getClusterInsertInvalidations in class Dialect
    
    Returns:
    an SQL statement with parameters for: id, fragments, kind
  - getClusterGetInvalidations
```
public String getClusterGetInvalidations()
```
    Description copied from class: Dialect
    
    Gets the SQL to query invalidations for this cluster node.
    
    Overrides:
    
    getClusterGetInvalidations in class Dialect
    
    Returns:
    an SQL statement returning a result set
  - isConnectionClosedException
```
public boolean isConnectionClosedException(Throwable t)
```
    Description copied from class: Dialect
    
    Checks if an exception received means that the low level connection has been trashed and must be reset.
    
    Overrides:
    
    isConnectionClosedException in class Dialect
  - isConcurrentUpdateException
```
public boolean isConcurrentUpdateException(Throwable t)
```
    Description copied from class: Dialect
    
    Checks if an exception received means that a concurrent update was detected.
    
    Overrides:
    
    isConcurrentUpdateException in class Dialect
  - supportsPaging
```
public boolean supportsPaging()
```
    Description copied from class: Dialect
    
    Indicates if dialect supports paging
    
    Overrides:
    
    supportsPaging in class Dialect
    
    Returns:
    true if the dialect supports paging
  - addPagingClause
```
public String addPagingClause(String sql,
                     long limit,
                     long offset)
```
    Description copied from class: Dialect
    
    Returns the SQL query with a paging clause
    
    Overrides:
    
    addPagingClause in class Dialect
  - supportsWith
```
public boolean supportsWith()
```
    Description copied from class: Dialect
    
    Does the dialect support SQL-99 WITH common table expressions.
    
    Overrides:
    
    supportsWith in class Dialect
  - performAdditionalStatements
```
public void performAdditionalStatements(Connection connection)
                                 throws SQLException
```
    Description copied from class: Dialect
    
    Let the dialect processes additional statements after tables creation and conditional statements. Can be used for specific upgrade procedure.
    
    Overrides:
    
    performAdditionalStatements in class Dialect
    
    Throws:
    
    SQLException
  - getUsersSeparator
```
public String getUsersSeparator()
```
  - getValidationQuery
```
public String getValidationQuery()
```
    Description copied from class: Dialect
    
    A query that, when executed, will make at least a round-trip to the server to check that the connection is alive.
    The query should throw an error if the connection is dead.
    
    Overrides:
    
    getValidationQuery in class Dialect
  - getAncestorsIdsSql
```
public String getAncestorsIdsSql()
```
    Description copied from class: Dialect
    
    Gets the SQL query to get the ancestors of a set of ids.
    
    Overrides:
    
    getAncestorsIdsSql in class Dialect
    
    Returns:
    null if not available
  - needsNullsLastOnDescSort
```
public boolean needsNullsLastOnDescSort()
```
    Description copied from class: Dialect
    
    True if the dialect need an extra NULLS LAST on DESC sort.
    
    Overrides:
    
    needsNullsLastOnDescSort in class Dialect
  - getDateCast
```
public String getDateCast()
```
    Description copied from class: Dialect
    
    Get the expression to use to cast a column to a DATE type.
    
    Overrides:
    
    getDateCast in class Dialect
    
    Returns:
    a pattern for String.format with one parameter for the column name
  - castIdToVarchar
```
public String castIdToVarchar(String expr)
```
    Description copied from class: Dialect
    
    Casts an id column to a VARCHAR type.
    Used for uuid/varchar joins.
    
    Overrides:
    
    castIdToVarchar in class Dialect
    
    Returns:
    the casted expression
  - getIdType
```
public Dialect.DialectIdType getIdType()
```
    Description copied from class: Dialect
    
    Gets the type of id when stored in the database.
    
    Overrides:
    
    getIdType in class Dialect
  - getSoftDeleteSql
```
public String getSoftDeleteSql()
```
    Description copied from class: Dialect
    
    SQL to soft delete documents. SQL returned has free parameters for the array of ids and time.
    
    Overrides:
    
    getSoftDeleteSql in class Dialect
  - getSoftDeleteCleanupSql
```
public String getSoftDeleteCleanupSql()
```
    Description copied from class: Dialect
    
    SQL to clean soft-delete documents. SQL returned has free parameters max and beforeTime.
    
    Overrides:
    
    getSoftDeleteCleanupSql in class Dialect
  - getBinaryFulltextSql
```
public String getBinaryFulltextSql(List<String> columns)
```
    Description copied from class: Dialect
    
    Return the SQL to get the columns fulltext fields
    
    Overrides:
    
    getBinaryFulltextSql in class Dialect

Class DialectPostgreSQL

Nested Class Summary

Nested classes/interfaces inherited from class org.nuxeo.ecm.core.storage.sql.jdbc.dialect.Dialect

Field Summary

Fields inherited from class org.nuxeo.ecm.core.storage.sql.jdbc.dialect.Dialect

Constructor Summary

Method Summary

Methods inherited from class org.nuxeo.ecm.core.storage.sql.jdbc.dialect.Dialect

Methods inherited from class java.lang.Object

Constructor Detail

DialectPostgreSQL

Method Detail

toBooleanValueString

getNoColumnsInsertString

getCascadeDropConstraintsString

getJDBCTypeAndString

isAllowedConversion

getGeneratedId

setId

getId

setToPreparedStatement

getFromResultSet

getColumnName

getCreateFulltextIndexSql

getDialectFulltextQuery

getFulltextScoredMatchInfo

getMaterializeFulltextSyntheticColumn

getFulltextIndexedColumns

getFreeVariableSetterForType

supportsUpdateFrom

doesUpdateFromRepeatSelf

needsAliasForDerivedTable

supportsIlike

supportsReadAcl

getPrepareUserReadAclsSql

getReadAclsCheckSql

getUpdateReadAclsSql

getRebuildReadAclsSql

getSecurityCheckSql

supportsAncestorsTable

getInTreeSql

getMatchMixinType

supportsSysNameArray

supportsArrays

supportsArrayColumns

getArraySubQuery

getArrayElementString

getArrayInSql

getArrayLikeSql

getArrayIlikeSql

createArrayOf

getSQLStatementsFilename

getTestSQLStatementsFilename

getSQLStatementsProperties

preCreateTable

getPostCreateTableSqls

existingTableDetected

isClusteringSupported

getClusterInsertInvalidations

getClusterGetInvalidations

isConnectionClosedException

isConcurrentUpdateException

supportsPaging

addPagingClause

supportsWith

performAdditionalStatements

getUsersSeparator

getValidationQuery

getAncestorsIdsSql

needsNullsLastOnDescSort

getDateCast

castIdToVarchar

getIdType

getSoftDeleteSql

getSoftDeleteCleanupSql

getBinaryFulltextSql