java.lang.Object
- org.hibernate.dialect.Dialect
- - org.hibernate.community.dialect.PostgreSQLLegacyDialect

All Implemented Interfaces:

org.hibernate.boot.model.FunctionContributor, org.hibernate.boot.model.TypeContributor, org.hibernate.exception.spi.ConversionContext

Direct Known Subclasses:

PostgresPlusLegacyDialect, PostgreSQL81Dialect, PostgreSQL82Dialect, PostgreSQL91Dialect, PostgreSQL92Dialect, PostgreSQL93Dialect, PostgreSQL94Dialect, PostgreSQL95Dialect, PostgreSQL9Dialect
```
public class PostgreSQLLegacyDialect
extends org.hibernate.dialect.Dialect
```
A SQL dialect for PostgreSQL 8 and above.

Nested Class Summary
- Nested classes/interfaces inherited from class org.hibernate.dialect.Dialect
  org.hibernate.dialect.Dialect.SizeStrategy, org.hibernate.dialect.Dialect.SizeStrategyImpl

Field Summary

Fields
Modifier and Type Field Description

protected org.hibernate.dialect.PostgreSQLDriverKind driverKind
- Fields inherited from class org.hibernate.dialect.Dialect
  CLOSED_QUOTE, LEGACY_LOB_MERGE_STRATEGY, LOG_BASE2OF10, NEW_LOCATOR_LOB_MERGE_STRATEGY, QUOTE, STANDARD_MULTI_KEY_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY

Constructor Summary

Constructors
Constructor	Description
`PostgreSQLLegacyDialect()`
`PostgreSQLLegacyDialect(org.hibernate.dialect.DatabaseVersion version)`
`PostgreSQLLegacyDialect(org.hibernate.dialect.DatabaseVersion version, org.hibernate.dialect.PostgreSQLDriverKind driverKind)`
`PostgreSQLLegacyDialect(org.hibernate.engine.jdbc.dialect.spi.DialectResolutionInfo info)`

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method	Description
`void`	`appendBinaryLiteral(org.hibernate.sql.ast.spi.SqlAppender appender, byte[] bytes)`
`void`	`appendBooleanValueString(org.hibernate.sql.ast.spi.SqlAppender appender, boolean bool)`
`void`	`appendDatetimeFormat(org.hibernate.sql.ast.spi.SqlAppender appender, String format)`
`void`	`appendDateTimeLiteral(org.hibernate.sql.ast.spi.SqlAppender appender, TemporalAccessor temporalAccessor, TemporalType precision, TimeZone jdbcTimeZone)`
`void`	`appendDateTimeLiteral(org.hibernate.sql.ast.spi.SqlAppender appender, Calendar calendar, TemporalType precision, TimeZone jdbcTimeZone)`
`void`	`appendDateTimeLiteral(org.hibernate.sql.ast.spi.SqlAppender appender, Date date, TemporalType precision, TimeZone jdbcTimeZone)`
`void`	`augmentRecognizedTableTypes(List<String> tableTypesList)`
`org.hibernate.engine.jdbc.env.spi.IdentifierHelper`	`buildIdentifierHelper(org.hibernate.engine.jdbc.env.spi.IdentifierHelperBuilder builder, DatabaseMetaData dbMetaData)`
`org.hibernate.exception.spi.SQLExceptionConversionDelegate`	`buildSQLExceptionConversionDelegate()`
`boolean`	`canBatchTruncate()`
`protected String`	`castType(int sqlTypeCode)`
`protected String`	`columnType(int sqlTypeCode)`
`protected void`	`contributePostgreSQLTypes(org.hibernate.boot.model.TypeContributions typeContributions, org.hibernate.service.ServiceRegistry serviceRegistry)`
`void`	`contributeTypes(org.hibernate.boot.model.TypeContributions typeContributions, org.hibernate.service.ServiceRegistry serviceRegistry)`
`String`	`currentTime()`
`String`	`currentTimestamp()`
`String`	`currentTimestampWithTimeZone()`
`org.hibernate.dialect.Replacer`	`datetimeFormat(String format)`
`protected void`	`extractField(StringBuilder pattern, org.hibernate.query.sqm.TemporalUnit unit, TemporalType fromTimestamp, TemporalType toTimestamp, org.hibernate.query.sqm.TemporalUnit toUnit)`	Deprecated.
`String`	`extractPattern(org.hibernate.query.sqm.TemporalUnit unit)`	The `extract()` function returns `TemporalUnit.DAY_OF_WEEK` numbered from 0 to 6.
`org.hibernate.dialect.aggregate.AggregateSupport`	`getAggregateSupport()`
`org.hibernate.procedure.spi.CallableStatementSupport`	`getCallableStatementSupport()`
`String`	`getCascadeConstraintsString()`
`String`	`getCaseInsensitiveLike()`
`String`	`getCurrentSchemaCommand()`
`String`	`getCurrentTimestampSelectString()`
`boolean`	`getDefaultNonContextualLobCreation()`
`int`	`getDefaultStatementBatchSize()`
`org.hibernate.query.sqm.mutation.spi.SqmMultiTableInsertStrategy`	`getFallbackSqmInsertStrategy(org.hibernate.metamodel.mapping.EntityMappingType rootEntityDescriptor, org.hibernate.metamodel.spi.RuntimeModelCreationContext runtimeModelCreationContext)`
`org.hibernate.query.sqm.mutation.spi.SqmMultiTableMutationStrategy`	`getFallbackSqmMutationStrategy(org.hibernate.metamodel.mapping.EntityMappingType rootEntityDescriptor, org.hibernate.metamodel.spi.RuntimeModelCreationContext runtimeModelCreationContext)`
`String`	`getForUpdateNowaitString()`
`String`	`getForUpdateNowaitString(String aliases)`
`String`	`getForUpdateSkipLockedString()`
`String`	`getForUpdateSkipLockedString(String aliases)`
`String`	`getForUpdateString(String aliases)`
`String`	`getForUpdateString(String aliases, org.hibernate.LockOptions lockOptions)`
`long`	`getFractionalSecondPrecisionInNanos()`	`microsecond` is the smallest unit for an `interval`, and the highest precision for a `timestamp`, so we could use it as the "native" precision, but it's more convenient to use whole seconds (with the fractional part), since we want to use `extract(epoch from ...)` in our emulation of `timestampdiff()`.
`org.hibernate.dialect.SelectItemReferenceStrategy`	`getGroupBySelectItemReferenceStrategy()`
`org.hibernate.dialect.identity.IdentityColumnSupport`	`getIdentityColumnSupport()`
`org.hibernate.dialect.pagination.LimitHandler`	`getLimitHandler()`
`int`	`getMaxIdentifierLength()`
`int`	`getMaxVarbinaryLength()`
`int`	`getMaxVarcharCapacity()`
`int`	`getMaxVarcharLength()`
`org.hibernate.engine.jdbc.env.spi.NameQualifierSupport`	`getNameQualifierSupport()`
`org.hibernate.dialect.NationalizationSupport`	`getNationalizationSupport()`
`String`	`getNativeIdentifierGeneratorStrategy()`
`String`	`getNoColumnsInsertString()`
`String`	`getQuerySequencesString()`
`String`	`getReadLockString(int timeout)`
`String`	`getReadLockString(String aliases, int timeout)`
`ResultSet`	`getResultSet(CallableStatement ps)`
`ResultSet`	`getResultSet(CallableStatement statement, int position)`
`ResultSet`	`getResultSet(CallableStatement statement, String name)`
`String`	`getSelectClauseNullString(int sqlType, org.hibernate.type.spi.TypeConfiguration typeConfiguration)`
`org.hibernate.dialect.sequence.SequenceSupport`	`getSequenceSupport()`
`org.hibernate.sql.ast.SqlAstTranslatorFactory`	`getSqlAstTranslatorFactory()`
`org.hibernate.dialect.TimeZoneSupport`	`getTimeZoneSupport()`
`org.hibernate.dialect.unique.UniqueDelegate`	`getUniqueDelegate()`
`org.hibernate.exception.spi.ViolatedConstraintNameExtractor`	`getViolatedConstraintNameExtractor()`
`String`	`getWriteLockString(int timeout)`
`String`	`getWriteLockString(String aliases, int timeout)`
`org.hibernate.dialect.RowLockStrategy`	`getWriteRowLockStrategy()`
`void`	`initializeFunctionRegistry(org.hibernate.boot.model.FunctionContributions functionContributions)`
`boolean`	`isCurrentTimestampSelectStringCallable()`
`boolean`	`qualifyIndexName()`
`protected void`	`registerColumnTypes(org.hibernate.boot.model.TypeContributions typeContributions, org.hibernate.service.ServiceRegistry serviceRegistry)`
`int`	`registerResultSetOutParameter(CallableStatement statement, int col)`
`boolean`	`requiresParensForTupleDistinctCounts()`
`protected Integer`	`resolveSqlTypeCode(String columnTypeName, org.hibernate.type.spi.TypeConfiguration typeConfiguration)`
`org.hibernate.type.descriptor.jdbc.JdbcType`	`resolveSqlTypeDescriptor(String columnTypeName, int jdbcTypeCode, int precision, int scale, org.hibernate.type.descriptor.jdbc.spi.JdbcTypeRegistry jdbcTypeRegistry)`
`String`	`rowId(String rowId)`
`int`	`rowIdSqlType()`
`boolean`	`supportsCaseInsensitiveLike()`
`boolean`	`supportsCommentOn()`
`boolean`	`supportsCurrentTimestampSelection()`
`boolean`	`supportsDistinctFromPredicate()`
`boolean`	`supportsFetchClause(org.hibernate.query.sqm.FetchClauseType type)`
`boolean`	`supportsIfExistsAfterAlterTable()`
`boolean`	`supportsIfExistsBeforeConstraintName()`
`boolean`	`supportsIfExistsBeforeTableName()`
`boolean`	`supportsIfExistsBeforeTypeName()`
`boolean`	`supportsJdbcConnectionLobCreation(DatabaseMetaData databaseMetaData)`
`boolean`	`supportsLateral()`
`boolean`	`supportsLobValueChangePropagation()`
`boolean`	`supportsMaterializedLobAccess()`
`protected boolean`	`supportsMinMaxOnUuid()`	Whether PostgreSQL supports `min(uuid)`/`max(uuid)` which it doesn't by default.
`boolean`	`supportsNonQueryWithCTE()`
`boolean`	`supportsNoWait()`
`boolean`	`supportsOffsetInSubquery()`
`boolean`	`supportsOuterJoinForUpdate()`
`boolean`	`supportsPartitionBy()`
`boolean`	`supportsRecursiveCTE()`
`boolean`	`supportsSkipLocked()`
`boolean`	`supportsStandardArrays()`
`boolean`	`supportsTemporalLiteralOffset()`
`boolean`	`supportsTupleCounts()`
`boolean`	`supportsUnboundedLobLocatorMaterialization()`
`boolean`	`supportsValuesList()`
`boolean`	`supportsWait()`
`boolean`	`supportsWindowFunctions()`
`String`	`timestampaddPattern(org.hibernate.query.sqm.TemporalUnit unit, TemporalType temporalType, org.hibernate.query.sqm.IntervalType intervalType)`
`String`	`timestampdiffPattern(org.hibernate.query.sqm.TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType)`
`String`	`translateExtractField(org.hibernate.query.sqm.TemporalUnit unit)`
`boolean`	`useInputStreamToInsertBlob()`

Methods inherited from class org.hibernate.dialect.Dialect
addSqlHintOrComment, appendArrayLiteral, appendIntervalLiteral, appendLiteral, appendLockHint, appendUUIDLiteral, applyLocksToSql, augmentPhysicalTableTypes, canCreateCatalog, canCreateSchema, canDisableConstraints, castPattern, checkVersion, closeQuote, contribute, contributeFunctions, createOptionalTableUpdateOperation, currentDate, currentLocalTime, currentLocalTimestamp, defaultScrollMode, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, dropConstraints, equivalentTypes, escapeComment, forceLobAsLastValue, generatedAs, getAddColumnString, getAddColumnSuffixString, getAddForeignKeyConstraintString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAlterColumnTypeString, getAlterTableString, getArrayTypeName, getAuxiliaryDatabaseObjectExporter, getBatchLoadSizingStrategy, getCheckCondition, getCheckCondition, getColumnAliasExtractor, getColumnComment, getCreateCatalogCommand, getCreateIndexString, getCreateIndexTail, getCreateMultisetTableString, getCreateSchemaCommand, getCreateTableString, getCreateTemporaryTableColumnAnnotation, getCreateUserDefinedTypeExtensionsString, getCreateUserDefinedTypeKindString, getDefaultDecimalPrecision, getDefaultLobLength, getDefaultProperties, getDefaultTimestampPrecision, getDefaultUseGetGeneratedKeys, getDisableConstraintsStatement, getDisableConstraintStatement, getDmlTargetColumnQualifierSupport, getDoublePrecision, getDropCatalogCommand, getDropForeignKeyString, getDropSchemaCommand, getDropTableString, getDropUniqueKeyString, getEnableConstraintsStatement, getEnableConstraintStatement, getEnumTypeDeclaration, getFallbackSchemaManagementTool, getFloatPrecision, getForeignKeyExporter, getForUpdateString, getForUpdateString, getForUpdateString, getHqlTranslator, getIndexExporter, getInExpressionCountLimit, getKeywords, getLobMergeStrategy, getLockingStrategy, getLockRowIdentifier, getLowercaseFunction, getMaxAliasLength, getMaxNVarcharCapacity, getMaxNVarcharLength, getMaxVarbinaryCapacity, getMinimumSupportedVersion, getMultiKeyLoadSizingStrategy, getNativeIdentifierGenerationType, getNativeParameterMarkerStrategy, getNullColumnString, getNullColumnString, getNullOrdering, getParameterCountLimit, getPreferredSqlTypeCodeForArray, getPreferredSqlTypeCodeForBoolean, getQueryHintString, getQueryHintString, getReadRowLockStrategy, getRowIdColumnString, getSchemaNameResolver, getSelectGUIDString, getSequenceExporter, getSequenceInformationExtractor, getSizeStrategy, getSqmTranslatorFactory, getSupportedTemporaryTableKind, getTableCleaner, getTableComment, getTableExporter, getTableMigrator, getTableTypeString, getTemporaryTableAfterUseAction, getTemporaryTableBeforeUseAction, getTemporaryTableCreateCommand, getTemporaryTableCreateOptions, getTemporaryTableDdlTransactionHandling, getTemporaryTableDropCommand, getTemporaryTableExporter, getTemporaryTableTruncateCommand, getTimeoutInSeconds, getTruncateTableStatement, getTruncateTableStatements, getUniqueKeyExporter, getUserDefinedTypeComment, getUserDefinedTypeExporter, getVersion, hasAlterTable, hasDataTypeBeforeGeneratedAs, hasSelfReferentialForeignKeyBug, initDefaultProperties, inlineLiteral, isAnsiNullOn, isEmptyStringTreatedAsNull, isJdbcLogWarningsEnabledByDefault, isLob, isLockTimeoutParameterized, openQuote, ordinal, prependComment, quote, registerDefaultKeywords, registerKeyword, registerKeywords, registerResultSetOutParameter, requiresCastForConcatenatingNonStrings, requiresFloatCastingOfIntegerDivision, requiresParensForTupleCounts, resolveSqlTypeCode, resolveSqlTypeLength, supportsAlterColumnType, supportsBindAsCallableArgument, supportsBitType, supportsCascadeDelete, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsExistsInSelect, supportsExpectedLobUsagePattern, supportsFractionalTimestampArithmetic, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsAfterTypeName, supportsInsertReturning, supportsInsertReturningGeneratedKeys, supportsLockTimeouts, supportsNamedParameters, supportsNoColumnsInsert, supportsNullPrecedence, supportsOrderByInSubquery, supportsOrdinalSelectItemReference, supportsParametersInInsertSelect, supportsPredicateAsExpression, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsStandardCurrentTimestampFunction, supportsSubqueryInSelect, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTemporaryTablePrimaryKey, supportsTemporaryTables, supportsTruncateWithCast, supportsTupleDistinctCounts, supportsUnionAll, supportsUnionInSubquery, supportsValuesListForInsert, toBooleanValueString, toQuotedIdentifier, toString, transformSelectString, translateDurationField, trimPattern, useArrayForMultiValuedParameters, useFollowOnLocking, useMaterializedLobWhenCapacityExceeded

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

- Field Detail
  - driverKind
```
protected final org.hibernate.dialect.PostgreSQLDriverKind driverKind
```
- Constructor Detail
  - PostgreSQLLegacyDialect
```
public PostgreSQLLegacyDialect()
```
  - PostgreSQLLegacyDialect
```
public PostgreSQLLegacyDialect(org.hibernate.engine.jdbc.dialect.spi.DialectResolutionInfo info)
```
  - PostgreSQLLegacyDialect
```
public PostgreSQLLegacyDialect(org.hibernate.dialect.DatabaseVersion version)
```
  - PostgreSQLLegacyDialect
```
public PostgreSQLLegacyDialect(org.hibernate.dialect.DatabaseVersion version,
                               org.hibernate.dialect.PostgreSQLDriverKind driverKind)
```
- Method Detail
  - getDefaultNonContextualLobCreation
```
public boolean getDefaultNonContextualLobCreation()
```
    Overrides:
    
    getDefaultNonContextualLobCreation in class org.hibernate.dialect.Dialect
  - columnType
```
protected String columnType(int sqlTypeCode)
```
    Overrides:
    
    columnType in class org.hibernate.dialect.Dialect
  - castType
```
protected String castType(int sqlTypeCode)
```
    Overrides:
    
    castType in class org.hibernate.dialect.Dialect
  - registerColumnTypes
```
protected void registerColumnTypes(org.hibernate.boot.model.TypeContributions typeContributions,
                                   org.hibernate.service.ServiceRegistry serviceRegistry)
```
    Overrides:
    
    registerColumnTypes in class org.hibernate.dialect.Dialect
  - getMaxVarcharLength
```
public int getMaxVarcharLength()
```
    Overrides:
    
    getMaxVarcharLength in class org.hibernate.dialect.Dialect
  - getMaxVarcharCapacity
```
public int getMaxVarcharCapacity()
```
    Overrides:
    
    getMaxVarcharCapacity in class org.hibernate.dialect.Dialect
  - getMaxVarbinaryLength
```
public int getMaxVarbinaryLength()
```
    Overrides:
    
    getMaxVarbinaryLength in class org.hibernate.dialect.Dialect
  - getDefaultStatementBatchSize
```
public int getDefaultStatementBatchSize()
```
    Overrides:
    
    getDefaultStatementBatchSize in class org.hibernate.dialect.Dialect
  - resolveSqlTypeDescriptor
```
public org.hibernate.type.descriptor.jdbc.JdbcType resolveSqlTypeDescriptor(String columnTypeName,
                                                                            int jdbcTypeCode,
                                                                            int precision,
                                                                            int scale,
                                                                            org.hibernate.type.descriptor.jdbc.spi.JdbcTypeRegistry jdbcTypeRegistry)
```
    Overrides:
    
    resolveSqlTypeDescriptor in class org.hibernate.dialect.Dialect
  - resolveSqlTypeCode
```
protected Integer resolveSqlTypeCode(String columnTypeName,
                                     org.hibernate.type.spi.TypeConfiguration typeConfiguration)
```
    Overrides:
    
    resolveSqlTypeCode in class org.hibernate.dialect.Dialect
  - currentTime
```
public String currentTime()
```
    Overrides:
    
    currentTime in class org.hibernate.dialect.Dialect
  - currentTimestamp
```
public String currentTimestamp()
```
    Overrides:
    
    currentTimestamp in class org.hibernate.dialect.Dialect
  - currentTimestampWithTimeZone
```
public String currentTimestampWithTimeZone()
```
    Overrides:
    
    currentTimestampWithTimeZone in class org.hibernate.dialect.Dialect
  - extractPattern
```
public String extractPattern(org.hibernate.query.sqm.TemporalUnit unit)
```
    The extract() function returns TemporalUnit.DAY_OF_WEEK numbered from 0 to 6. This isn't consistent with what most other databases do, so here we adjust the result by generating (extract(dow,arg)+1)).
    
    Overrides:
    
    extractPattern in class org.hibernate.dialect.Dialect
  - getFractionalSecondPrecisionInNanos
```
public long getFractionalSecondPrecisionInNanos()
```
    microsecond is the smallest unit for an interval, and the highest precision for a timestamp, so we could use it as the "native" precision, but it's more convenient to use whole seconds (with the fractional part), since we want to use extract(epoch from ...) in our emulation of timestampdiff().
    
    Overrides:
    
    getFractionalSecondPrecisionInNanos in class org.hibernate.dialect.Dialect
  - timestampaddPattern
```
public String timestampaddPattern(org.hibernate.query.sqm.TemporalUnit unit,
                                  TemporalType temporalType,
                                  org.hibernate.query.sqm.IntervalType intervalType)
```
    Overrides:
    
    timestampaddPattern in class org.hibernate.dialect.Dialect
  - timestampdiffPattern
```
public String timestampdiffPattern(org.hibernate.query.sqm.TemporalUnit unit,
                                   TemporalType fromTemporalType,
                                   TemporalType toTemporalType)
```
    Overrides:
    
    timestampdiffPattern in class org.hibernate.dialect.Dialect
  - extractField
```
@Deprecated
protected void extractField(StringBuilder pattern,
                            org.hibernate.query.sqm.TemporalUnit unit,
                            TemporalType fromTimestamp,
                            TemporalType toTimestamp,
                            org.hibernate.query.sqm.TemporalUnit toUnit)
```
    Deprecated.
  - getTimeZoneSupport
```
public org.hibernate.dialect.TimeZoneSupport getTimeZoneSupport()
```
    Overrides:
    
    getTimeZoneSupport in class org.hibernate.dialect.Dialect
  - initializeFunctionRegistry
```
public void initializeFunctionRegistry(org.hibernate.boot.model.FunctionContributions functionContributions)
```
    Overrides:
    
    initializeFunctionRegistry in class org.hibernate.dialect.Dialect
  - supportsMinMaxOnUuid
```
protected boolean supportsMinMaxOnUuid()
```
    Whether PostgreSQL supports `min(uuid)`/`max(uuid)` which it doesn't by default. Since the emulation is not very performant, this can be overridden by users which make sure that an aggregate function for uuid exists on their database. The following definitions can be used for this purpose: create or replace function min(uuid, uuid) returns uuid immutable parallel safe language plpgsql as $$ begin return least($1, $2); end $$; create aggregate min(uuid) ( sfunc = min, stype = uuid, combinefunc = min, parallel = safe, sortop = operator (<) ); create or replace function max(uuid, uuid) returns uuid immutable parallel safe language plpgsql as $$ begin return greatest($1, $2); end $$; create aggregate max(uuid) ( sfunc = max, stype = uuid, combinefunc = max, parallel = safe, sortop = operator (>) );
  - getNameQualifierSupport
```
public org.hibernate.engine.jdbc.env.spi.NameQualifierSupport getNameQualifierSupport()
```
    Overrides:
    
    getNameQualifierSupport in class org.hibernate.dialect.Dialect
  - getCurrentSchemaCommand
```
public String getCurrentSchemaCommand()
```
    Overrides:
    
    getCurrentSchemaCommand in class org.hibernate.dialect.Dialect
  - supportsDistinctFromPredicate
```
public boolean supportsDistinctFromPredicate()
```
    Overrides:
    
    supportsDistinctFromPredicate in class org.hibernate.dialect.Dialect
  - supportsIfExistsBeforeTableName
```
public boolean supportsIfExistsBeforeTableName()
```
    Overrides:
    
    supportsIfExistsBeforeTableName in class org.hibernate.dialect.Dialect
  - supportsIfExistsBeforeTypeName
```
public boolean supportsIfExistsBeforeTypeName()
```
    Overrides:
    
    supportsIfExistsBeforeTypeName in class org.hibernate.dialect.Dialect
  - supportsIfExistsBeforeConstraintName
```
public boolean supportsIfExistsBeforeConstraintName()
```
    Overrides:
    
    supportsIfExistsBeforeConstraintName in class org.hibernate.dialect.Dialect
  - supportsIfExistsAfterAlterTable
```
public boolean supportsIfExistsAfterAlterTable()
```
    Overrides:
    
    supportsIfExistsAfterAlterTable in class org.hibernate.dialect.Dialect
  - supportsValuesList
```
public boolean supportsValuesList()
```
    Overrides:
    
    supportsValuesList in class org.hibernate.dialect.Dialect
  - supportsPartitionBy
```
public boolean supportsPartitionBy()
```
    Overrides:
    
    supportsPartitionBy in class org.hibernate.dialect.Dialect
  - supportsNonQueryWithCTE
```
public boolean supportsNonQueryWithCTE()
```
    Overrides:
    
    supportsNonQueryWithCTE in class org.hibernate.dialect.Dialect
  - getSequenceSupport
```
public org.hibernate.dialect.sequence.SequenceSupport getSequenceSupport()
```
    Overrides:
    
    getSequenceSupport in class org.hibernate.dialect.Dialect
  - getCascadeConstraintsString
```
public String getCascadeConstraintsString()
```
    Overrides:
    
    getCascadeConstraintsString in class org.hibernate.dialect.Dialect
  - getQuerySequencesString
```
public String getQuerySequencesString()
```
    Overrides:
    
    getQuerySequencesString in class org.hibernate.dialect.Dialect
  - getLimitHandler
```
public org.hibernate.dialect.pagination.LimitHandler getLimitHandler()
```
    Overrides:
    
    getLimitHandler in class org.hibernate.dialect.Dialect
  - getForUpdateString
```
public String getForUpdateString(String aliases)
```
    Overrides:
    
    getForUpdateString in class org.hibernate.dialect.Dialect
  - getForUpdateString
```
public String getForUpdateString(String aliases,
                                 org.hibernate.LockOptions lockOptions)
```
    Overrides:
    
    getForUpdateString in class org.hibernate.dialect.Dialect
  - getNoColumnsInsertString
```
public String getNoColumnsInsertString()
```
    Overrides:
    
    getNoColumnsInsertString in class org.hibernate.dialect.Dialect
  - getCaseInsensitiveLike
```
public String getCaseInsensitiveLike()
```
    Overrides:
    
    getCaseInsensitiveLike in class org.hibernate.dialect.Dialect
  - supportsCaseInsensitiveLike
```
public boolean supportsCaseInsensitiveLike()
```
    Overrides:
    
    supportsCaseInsensitiveLike in class org.hibernate.dialect.Dialect
  - getNativeIdentifierGeneratorStrategy
```
public String getNativeIdentifierGeneratorStrategy()
```
    Overrides:
    
    getNativeIdentifierGeneratorStrategy in class org.hibernate.dialect.Dialect
  - supportsOuterJoinForUpdate
```
public boolean supportsOuterJoinForUpdate()
```
    Overrides:
    
    supportsOuterJoinForUpdate in class org.hibernate.dialect.Dialect
  - useInputStreamToInsertBlob
```
public boolean useInputStreamToInsertBlob()
```
    Overrides:
    
    useInputStreamToInsertBlob in class org.hibernate.dialect.Dialect
  - getSelectClauseNullString
```
public String getSelectClauseNullString(int sqlType,
                                        org.hibernate.type.spi.TypeConfiguration typeConfiguration)
```
    Overrides:
    
    getSelectClauseNullString in class org.hibernate.dialect.Dialect
  - supportsCommentOn
```
public boolean supportsCommentOn()
```
    Overrides:
    
    supportsCommentOn in class org.hibernate.dialect.Dialect
  - supportsCurrentTimestampSelection
```
public boolean supportsCurrentTimestampSelection()
```
    Overrides:
    
    supportsCurrentTimestampSelection in class org.hibernate.dialect.Dialect
  - isCurrentTimestampSelectStringCallable
```
public boolean isCurrentTimestampSelectStringCallable()
```
    Overrides:
    
    isCurrentTimestampSelectStringCallable in class org.hibernate.dialect.Dialect
  - getCurrentTimestampSelectString
```
public String getCurrentTimestampSelectString()
```
    Overrides:
    
    getCurrentTimestampSelectString in class org.hibernate.dialect.Dialect
  - supportsTupleCounts
```
public boolean supportsTupleCounts()
```
    Overrides:
    
    supportsTupleCounts in class org.hibernate.dialect.Dialect
  - requiresParensForTupleDistinctCounts
```
public boolean requiresParensForTupleDistinctCounts()
```
    Overrides:
    
    requiresParensForTupleDistinctCounts in class org.hibernate.dialect.Dialect
  - appendBooleanValueString
```
public void appendBooleanValueString(org.hibernate.sql.ast.spi.SqlAppender appender,
                                     boolean bool)
```
    Overrides:
    
    appendBooleanValueString in class org.hibernate.dialect.Dialect
  - buildIdentifierHelper
```
public org.hibernate.engine.jdbc.env.spi.IdentifierHelper buildIdentifierHelper(org.hibernate.engine.jdbc.env.spi.IdentifierHelperBuilder builder,
                                                                                DatabaseMetaData dbMetaData)
                                                                         throws SQLException
```
    Overrides:
    
    buildIdentifierHelper in class org.hibernate.dialect.Dialect
    
    Throws:
    
    SQLException
  - getFallbackSqmMutationStrategy
```
public org.hibernate.query.sqm.mutation.spi.SqmMultiTableMutationStrategy getFallbackSqmMutationStrategy(org.hibernate.metamodel.mapping.EntityMappingType rootEntityDescriptor,
                                                                                                         org.hibernate.metamodel.spi.RuntimeModelCreationContext runtimeModelCreationContext)
```
    Overrides:
    
    getFallbackSqmMutationStrategy in class org.hibernate.dialect.Dialect
  - getFallbackSqmInsertStrategy
```
public org.hibernate.query.sqm.mutation.spi.SqmMultiTableInsertStrategy getFallbackSqmInsertStrategy(org.hibernate.metamodel.mapping.EntityMappingType rootEntityDescriptor,
                                                                                                     org.hibernate.metamodel.spi.RuntimeModelCreationContext runtimeModelCreationContext)
```
    Overrides:
    
    getFallbackSqmInsertStrategy in class org.hibernate.dialect.Dialect
  - getSqlAstTranslatorFactory
```
public org.hibernate.sql.ast.SqlAstTranslatorFactory getSqlAstTranslatorFactory()
```
    Overrides:
    
    getSqlAstTranslatorFactory in class org.hibernate.dialect.Dialect
  - getViolatedConstraintNameExtractor
```
public org.hibernate.exception.spi.ViolatedConstraintNameExtractor getViolatedConstraintNameExtractor()
```
    Specified by:
    
    getViolatedConstraintNameExtractor in interface org.hibernate.exception.spi.ConversionContext
    
    Overrides:
    
    getViolatedConstraintNameExtractor in class org.hibernate.dialect.Dialect
  - buildSQLExceptionConversionDelegate
```
public org.hibernate.exception.spi.SQLExceptionConversionDelegate buildSQLExceptionConversionDelegate()
```
    Overrides:
    
    buildSQLExceptionConversionDelegate in class org.hibernate.dialect.Dialect
  - registerResultSetOutParameter
```
public int registerResultSetOutParameter(CallableStatement statement,
                                         int col)
                                  throws SQLException
```
    Overrides:
    
    registerResultSetOutParameter in class org.hibernate.dialect.Dialect
    
    Throws:
    
    SQLException
  - getResultSet
```
public ResultSet getResultSet(CallableStatement ps)
                       throws SQLException
```
    Overrides:
    
    getResultSet in class org.hibernate.dialect.Dialect
    
    Throws:
    
    SQLException
  - supportsLobValueChangePropagation
```
public boolean supportsLobValueChangePropagation()
```
    Overrides:
    
    supportsLobValueChangePropagation in class org.hibernate.dialect.Dialect
  - supportsUnboundedLobLocatorMaterialization
```
public boolean supportsUnboundedLobLocatorMaterialization()
```
    Overrides:
    
    supportsUnboundedLobLocatorMaterialization in class org.hibernate.dialect.Dialect
  - getGroupBySelectItemReferenceStrategy
```
public org.hibernate.dialect.SelectItemReferenceStrategy getGroupBySelectItemReferenceStrategy()
```
    Overrides:
    
    getGroupBySelectItemReferenceStrategy in class org.hibernate.dialect.Dialect
  - getCallableStatementSupport
```
public org.hibernate.procedure.spi.CallableStatementSupport getCallableStatementSupport()
```
    Overrides:
    
    getCallableStatementSupport in class org.hibernate.dialect.Dialect
  - getResultSet
```
public ResultSet getResultSet(CallableStatement statement,
                              int position)
                       throws SQLException
```
    Overrides:
    
    getResultSet in class org.hibernate.dialect.Dialect
    
    Throws:
    
    SQLException
  - getResultSet
```
public ResultSet getResultSet(CallableStatement statement,
                              String name)
                       throws SQLException
```
    Overrides:
    
    getResultSet in class org.hibernate.dialect.Dialect
    
    Throws:
    
    SQLException
  - qualifyIndexName
```
public boolean qualifyIndexName()
```
    Overrides:
    
    qualifyIndexName in class org.hibernate.dialect.Dialect
  - getIdentityColumnSupport
```
public org.hibernate.dialect.identity.IdentityColumnSupport getIdentityColumnSupport()
```
    Overrides:
    
    getIdentityColumnSupport in class org.hibernate.dialect.Dialect
  - getNationalizationSupport
```
public org.hibernate.dialect.NationalizationSupport getNationalizationSupport()
```
    Overrides:
    
    getNationalizationSupport in class org.hibernate.dialect.Dialect
  - getMaxIdentifierLength
```
public int getMaxIdentifierLength()
```
    Overrides:
    
    getMaxIdentifierLength in class org.hibernate.dialect.Dialect
  - supportsStandardArrays
```
public boolean supportsStandardArrays()
```
    Overrides:
    
    supportsStandardArrays in class org.hibernate.dialect.Dialect
  - supportsJdbcConnectionLobCreation
```
public boolean supportsJdbcConnectionLobCreation(DatabaseMetaData databaseMetaData)
```
    Overrides:
    
    supportsJdbcConnectionLobCreation in class org.hibernate.dialect.Dialect
  - supportsMaterializedLobAccess
```
public boolean supportsMaterializedLobAccess()
```
    Overrides:
    
    supportsMaterializedLobAccess in class org.hibernate.dialect.Dialect
  - supportsTemporalLiteralOffset
```
public boolean supportsTemporalLiteralOffset()
```
    Overrides:
    
    supportsTemporalLiteralOffset in class org.hibernate.dialect.Dialect
  - appendDatetimeFormat
```
public void appendDatetimeFormat(org.hibernate.sql.ast.spi.SqlAppender appender,
                                 String format)
```
    Overrides:
    
    appendDatetimeFormat in class org.hibernate.dialect.Dialect
  - datetimeFormat
```
public org.hibernate.dialect.Replacer datetimeFormat(String format)
```
  - translateExtractField
```
public String translateExtractField(org.hibernate.query.sqm.TemporalUnit unit)
```
    Overrides:
    
    translateExtractField in class org.hibernate.dialect.Dialect
  - getAggregateSupport
```
public org.hibernate.dialect.aggregate.AggregateSupport getAggregateSupport()
```
    Overrides:
    
    getAggregateSupport in class org.hibernate.dialect.Dialect
  - appendBinaryLiteral
```
public void appendBinaryLiteral(org.hibernate.sql.ast.spi.SqlAppender appender,
                                byte[] bytes)
```
    Overrides:
    
    appendBinaryLiteral in class org.hibernate.dialect.Dialect
  - appendDateTimeLiteral
```
public void appendDateTimeLiteral(org.hibernate.sql.ast.spi.SqlAppender appender,
                                  TemporalAccessor temporalAccessor,
                                  TemporalType precision,
                                  TimeZone jdbcTimeZone)
```
    Overrides:
    
    appendDateTimeLiteral in class org.hibernate.dialect.Dialect
  - appendDateTimeLiteral
```
public void appendDateTimeLiteral(org.hibernate.sql.ast.spi.SqlAppender appender,
                                  Date date,
                                  TemporalType precision,
                                  TimeZone jdbcTimeZone)
```
    Overrides:
    
    appendDateTimeLiteral in class org.hibernate.dialect.Dialect
  - appendDateTimeLiteral
```
public void appendDateTimeLiteral(org.hibernate.sql.ast.spi.SqlAppender appender,
                                  Calendar calendar,
                                  TemporalType precision,
                                  TimeZone jdbcTimeZone)
```
    Overrides:
    
    appendDateTimeLiteral in class org.hibernate.dialect.Dialect
  - getWriteLockString
```
public String getWriteLockString(int timeout)
```
    Overrides:
    
    getWriteLockString in class org.hibernate.dialect.Dialect
  - getWriteLockString
```
public String getWriteLockString(String aliases,
                                 int timeout)
```
    Overrides:
    
    getWriteLockString in class org.hibernate.dialect.Dialect
  - getReadLockString
```
public String getReadLockString(int timeout)
```
    Overrides:
    
    getReadLockString in class org.hibernate.dialect.Dialect
  - getReadLockString
```
public String getReadLockString(String aliases,
                                int timeout)
```
    Overrides:
    
    getReadLockString in class org.hibernate.dialect.Dialect
  - getForUpdateNowaitString
```
public String getForUpdateNowaitString()
```
    Overrides:
    
    getForUpdateNowaitString in class org.hibernate.dialect.Dialect
  - getForUpdateNowaitString
```
public String getForUpdateNowaitString(String aliases)
```
    Overrides:
    
    getForUpdateNowaitString in class org.hibernate.dialect.Dialect
  - getForUpdateSkipLockedString
```
public String getForUpdateSkipLockedString()
```
    Overrides:
    
    getForUpdateSkipLockedString in class org.hibernate.dialect.Dialect
  - getForUpdateSkipLockedString
```
public String getForUpdateSkipLockedString(String aliases)
```
    Overrides:
    
    getForUpdateSkipLockedString in class org.hibernate.dialect.Dialect
  - supportsNoWait
```
public boolean supportsNoWait()
```
    Overrides:
    
    supportsNoWait in class org.hibernate.dialect.Dialect
  - supportsWait
```
public boolean supportsWait()
```
    Overrides:
    
    supportsWait in class org.hibernate.dialect.Dialect
  - supportsSkipLocked
```
public boolean supportsSkipLocked()
```
    Overrides:
    
    supportsSkipLocked in class org.hibernate.dialect.Dialect
  - supportsOffsetInSubquery
```
public boolean supportsOffsetInSubquery()
```
    Overrides:
    
    supportsOffsetInSubquery in class org.hibernate.dialect.Dialect
  - supportsWindowFunctions
```
public boolean supportsWindowFunctions()
```
    Overrides:
    
    supportsWindowFunctions in class org.hibernate.dialect.Dialect
  - supportsLateral
```
public boolean supportsLateral()
```
    Overrides:
    
    supportsLateral in class org.hibernate.dialect.Dialect
  - supportsRecursiveCTE
```
public boolean supportsRecursiveCTE()
```
    Overrides:
    
    supportsRecursiveCTE in class org.hibernate.dialect.Dialect
  - supportsFetchClause
```
public boolean supportsFetchClause(org.hibernate.query.sqm.FetchClauseType type)
```
    Overrides:
    
    supportsFetchClause in class org.hibernate.dialect.Dialect
  - getWriteRowLockStrategy
```
public org.hibernate.dialect.RowLockStrategy getWriteRowLockStrategy()
```
    Overrides:
    
    getWriteRowLockStrategy in class org.hibernate.dialect.Dialect
  - augmentRecognizedTableTypes
```
public void augmentRecognizedTableTypes(List<String> tableTypesList)
```
    Overrides:
    
    augmentRecognizedTableTypes in class org.hibernate.dialect.Dialect
  - contributeTypes
```
public void contributeTypes(org.hibernate.boot.model.TypeContributions typeContributions,
                            org.hibernate.service.ServiceRegistry serviceRegistry)
```
    Overrides:
    
    contributeTypes in class org.hibernate.dialect.Dialect
  - contributePostgreSQLTypes
```
protected void contributePostgreSQLTypes(org.hibernate.boot.model.TypeContributions typeContributions,
                                         org.hibernate.service.ServiceRegistry serviceRegistry)
```
  - getUniqueDelegate
```
public org.hibernate.dialect.unique.UniqueDelegate getUniqueDelegate()
```
    Overrides:
    
    getUniqueDelegate in class org.hibernate.dialect.Dialect
  - canBatchTruncate
```
public boolean canBatchTruncate()
```
    Overrides:
    
    canBatchTruncate in class org.hibernate.dialect.Dialect
    
    Returns:
    
    true, but only because we can "batch" truncate
  - rowId
```
public String rowId(String rowId)
```
    Overrides:
    
    rowId in class org.hibernate.dialect.Dialect
  - rowIdSqlType
```
public int rowIdSqlType()
```
    Overrides:
    
    rowIdSqlType in class org.hibernate.dialect.Dialect

Class PostgreSQLLegacyDialect

Nested Class Summary

Nested classes/interfaces inherited from class org.hibernate.dialect.Dialect

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect

Constructor Summary

Method Summary

Methods inherited from class org.hibernate.dialect.Dialect

Methods inherited from class java.lang.Object

Field Detail

driverKind

Constructor Detail

PostgreSQLLegacyDialect

PostgreSQLLegacyDialect

PostgreSQLLegacyDialect

PostgreSQLLegacyDialect

Method Detail

getDefaultNonContextualLobCreation

columnType

castType

registerColumnTypes

getMaxVarcharLength

getMaxVarcharCapacity

getMaxVarbinaryLength

getDefaultStatementBatchSize

resolveSqlTypeDescriptor

resolveSqlTypeCode

currentTime

currentTimestamp

currentTimestampWithTimeZone

extractPattern

getFractionalSecondPrecisionInNanos

timestampaddPattern

timestampdiffPattern

extractField

getTimeZoneSupport

initializeFunctionRegistry

supportsMinMaxOnUuid

getNameQualifierSupport

getCurrentSchemaCommand

supportsDistinctFromPredicate

supportsIfExistsBeforeTableName

supportsIfExistsBeforeTypeName

supportsIfExistsBeforeConstraintName

supportsIfExistsAfterAlterTable

supportsValuesList

supportsPartitionBy

supportsNonQueryWithCTE

getSequenceSupport

getCascadeConstraintsString

getQuerySequencesString

getLimitHandler

getForUpdateString

getForUpdateString

getNoColumnsInsertString

getCaseInsensitiveLike

supportsCaseInsensitiveLike

getNativeIdentifierGeneratorStrategy

supportsOuterJoinForUpdate

useInputStreamToInsertBlob

getSelectClauseNullString

supportsCommentOn

supportsCurrentTimestampSelection

isCurrentTimestampSelectStringCallable

getCurrentTimestampSelectString

supportsTupleCounts

requiresParensForTupleDistinctCounts

appendBooleanValueString

buildIdentifierHelper

getFallbackSqmMutationStrategy

getFallbackSqmInsertStrategy

getSqlAstTranslatorFactory

getViolatedConstraintNameExtractor

buildSQLExceptionConversionDelegate

registerResultSetOutParameter

getResultSet

supportsLobValueChangePropagation

supportsUnboundedLobLocatorMaterialization

getGroupBySelectItemReferenceStrategy

getCallableStatementSupport