Top Description Constructors Methods
org.hibernate.dialect

public Class PostgreSQL82Dialect

extends PostgreSQL81Dialect
Class Inheritance
Known Direct Subclasses
org.hibernate.dialect.PostgreSQL9Dialect, org.hibernate.dialect.PostgreSQLDialect
Imports
org.hibernate.boot.model.TypeContributions, org.hibernate.hql.spi.id.IdTableSupportStandardImpl, .MultiTableBulkIdStrategy, org.hibernate.hql.spi.id.local.AfterUseAction, .LocalTemporaryTableBulkIdStrategy, org.hibernate.service.ServiceRegistry, org.hibernate.type.PostgresUUIDType
An SQL dialect for Postgres 8.2 and later, adds support for "if exists" when dropping tables
Author
edalquist

Constructor Summary

AccessConstructor and Description
public
PostgreSQL82Dialect()

Method Summary

Modifier and TypeMethod and Description
public void
contributeTypes(TypeContributions
Callback to contribute the types
typeContributions, ServiceRegistry
The service registry
serviceRegistry)

Overrides org.hibernate.dialect.Dialect.contributeTypes.

Allows the Dialect to contribute additional types
public MultiTableBulkIdStrategy
getDefaultMultiTableBulkIdStrategy()

Overrides org.hibernate.dialect.PostgreSQL81Dialect.getDefaultMultiTableBulkIdStrategy.

public String
getDropSequenceString(String
The name of the sequence
sequenceName)

Overrides org.hibernate.dialect.PostgreSQL81Dialect.getDropSequenceString.

Typically dialects which support sequences can drop a sequence with a single command.
public boolean
supportsIfExistsBeforeTableName()

Overrides org.hibernate.dialect.Dialect.supportsIfExistsBeforeTableName.

For dropping a table, can the phrase "if exists" be applied before the table name?
public boolean
supportsRowValueConstructorSyntaxInInList()

Overrides org.hibernate.dialect.Dialect.supportsRowValueConstructorSyntaxInInList.

If the dialect supports row values, does it offer such support in IN lists as well?
public boolean
supportsValuesList()

Overrides org.hibernate.dialect.Dialect.supportsValuesList.

Does this dialect/database support VALUES list (e.g. VALUES (1), (2), (3) )
Inherited from org.hibernate.dialect.PostgreSQL81Dialect:
bindLimitParametersInReverseOrderbuildIdentifierHelperbuildSQLExceptionConversionDelegatedropConstraintsgetAddColumnStringgetCallableStatementSupportgetCascadeConstraintsStringgetCaseInsensitiveLikegetCreateSequenceStringgetCreateSequenceStringgetCurrentSchemaCommandgetCurrentTimestampSelectStringgetForUpdateNowaitStringgetForUpdateNowaitStringgetForUpdateStringgetForUpdateStringgetForUpdateStringgetIdentityColumnSupportgetLimitHandlergetLimitStringgetNameQualifierSupportgetNativeIdentifierGeneratorStrategygetNoColumnsInsertStringgetQuerySequencesStringgetReadLockStringgetReadLockStringgetResultSetgetResultSetgetResultSetgetSelectClauseNullStringgetSelectSequenceNextValStringgetSequenceNextValStringgetSqlTypeDescriptorOverridegetViolatedConstraintNameExtractergetWriteLockStringgetWriteLockStringisCurrentTimestampSelectStringCallablequalifyIndexNameregisterResultSetOutParameterrequiresParensForTupleDistinctCountssupportsCaseInsensitiveLikesupportsCommentOnsupportsCurrentTimestampSelectionsupportsEmptyInListsupportsExpectedLobUsagePatternsupportsJdbcConnectionLobCreationsupportsLimitsupportsLobValueChangePropogationsupportsNationalizedTypessupportsNoWaitsupportsOuterJoinForUpdatesupportsPooledSequencessupportsRowValueConstructorSyntaxsupportsSelectAliasInGroupByClausesupportsSequencessupportsUnboundedLobLocatorMaterializationsupportsUnionAlltoBooleanValueStringuseInputStreamToInsertBlob

Constructor Detail

PostgreSQL82Dialectback to summary
public PostgreSQL82Dialect()

Method Detail

contributeTypesback to summary
public void contributeTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)

Overrides org.hibernate.dialect.Dialect.contributeTypes.

Doc from org.hibernate.dialect.Dialect.contributeTypes.

Allows the Dialect to contribute additional types

Parameters
typeContributions:TypeContributions

Callback to contribute the types

serviceRegistry:ServiceRegistry

The service registry

Annotations
@Override
getDefaultMultiTableBulkIdStrategyback to summary
public MultiTableBulkIdStrategy getDefaultMultiTableBulkIdStrategy()

Overrides org.hibernate.dialect.PostgreSQL81Dialect.getDefaultMultiTableBulkIdStrategy.

Annotations
@Override
getDropSequenceStringback to summary
public String getDropSequenceString(String sequenceName)

Overrides org.hibernate.dialect.PostgreSQL81Dialect.getDropSequenceString.

Doc from org.hibernate.dialect.Dialect.getDropSequenceString.

Typically dialects which support sequences can drop a sequence with a single command. This is convenience form of getDropSequenceStrings to help facilitate that.

Dialects which support sequences and can drop a sequence in a single command need *only* override this method. Dialects which support sequences but require multiple commands to drop a sequence should instead override getDropSequenceStrings.

Parameters
sequenceName:String

The name of the sequence

Returns:String

The sequence drop commands

Annotations
@Override
supportsIfExistsBeforeTableNameback to summary
public boolean supportsIfExistsBeforeTableName()

Overrides org.hibernate.dialect.Dialect.supportsIfExistsBeforeTableName.

Doc from org.hibernate.dialect.Dialect.supportsIfExistsBeforeTableName.

For dropping a table, can the phrase "if exists" be applied before the table name?

NOTE : Only one or the other (or neither) of this and supportsIfExistsAfterTableName should return true

Returns:boolean

true if the "if exists" can be applied before the table name

Annotations
@Override
supportsRowValueConstructorSyntaxInInListback to summary
public boolean supportsRowValueConstructorSyntaxInInList()

Overrides org.hibernate.dialect.Dialect.supportsRowValueConstructorSyntaxInInList.

Doc from org.hibernate.dialect.Dialect.supportsRowValueConstructorSyntaxInInList.

If the dialect supports row values, does it offer such support in IN lists as well?

For example, "... where (FIRST_NAME, LAST_NAME) IN ( (?, ?), (?, ?) ) ..."

Returns:boolean

True if this SQL dialect is known to support "row value constructor" syntax in the IN list; false otherwise.

supportsValuesListback to summary
public boolean supportsValuesList()

Overrides org.hibernate.dialect.Dialect.supportsValuesList.

Doc from org.hibernate.dialect.Dialect.supportsValuesList.

Does this dialect/database support VALUES list (e.g. VALUES (1), (2), (3) )

Returns:boolean

true if VALUES list are supported

Annotations
@Override