net.sf.hajdbc.dialect.postgresql

Class PostgreSQLDialect

java.lang.Object

net.sf.hajdbc.dialect.StandardDialect

net.sf.hajdbc.dialect.postgresql.PostgreSQLDialect

All Implemented Interfaces:

Dialect, DumpRestoreSupport, IdentityColumnSupport, SequenceSupport, TriggerSupport

public class PostgreSQLDialect
extends StandardDialect
implements DumpRestoreSupport

Dialect for PostgreSQL.

Since:

1.1

Author:

Paul Ferraro

Nested Class Summary

Nested classes/interfaces inherited from interface net.sf.hajdbc.TriggerSupport

TriggerSupport.TriggerEventEnum, TriggerSupport.TriggerTimeEnum

Field Summary

Fields

Modifier and Type	Field and Description
static String[]	RESERVED_KEY_WORDS

Fields inherited from class net.sf.hajdbc.dialect.StandardDialect

SQL_2003_RESERVED_KEY_WORDS

Constructor Summary

Constructors

Constructor and Description
PostgreSQLDialect()

Method Summary

Methods

Modifier and Type	Method and Description
protected String	alterIdentityColumnFormat()
protected String	createTriggerFormat()
protected String	currentTimestampPattern()
protected String	dropTriggerFormat()
<Z,D extends Database<Z>> void	dump(D database, Decoder decoder, File file, boolean dataOnly)
int	getColumnType(ColumnProperties properties) PostgreSQL uses the native type OID to identify BLOBs.
List<String>	getDefaultSchemas(DatabaseMetaData metaData) PostgreSQL uses a schema search path to locate unqualified table names.
DumpRestoreSupport	getDumpRestoreSupport()
IdentityColumnSupport	getIdentityColumnSupport()
SequenceSupport	getSequenceSupport()
TriggerSupport	getTriggerSupport()
protected Pattern	identifierPattern(DatabaseMetaData metaData)
protected String	nextSequenceValueFormat()
protected String	randomPattern()
protected Set<String>	reservedIdentifiers(DatabaseMetaData metaData)
<Z,D extends Database<Z>> void	restore(D database, Decoder decoder, File file, boolean dataOnly)
protected String	selectForUpdatePattern() Recognizes FOR SHARE and FOR UPDATE.
protected String	sequencePattern()
protected String	truncateTableFormat()
protected String	vendorPattern()

Methods inherited from class net.sf.hajdbc.dialect.StandardDialect

alterSequenceFormat, createColumnPropertiesFactory, createForeignKeyConstraintFactory, createForeignKeyConstraintFormat, createIdentifierNormalizer, createQualifiedNameFactory, createSchemaFormat, createSequencePropertiesFactory, createUniqueConstraintFactory, createUniqueConstraintFormat, currentDatePattern, currentTimePattern, dateLiteralFormat, dropConstraintFormat, dropForeignKeyConstraintFormat, dropSchemaFormat, dropUniqueConstraintFormat, dummyTable, evaluateCurrentDate, evaluateCurrentTime, evaluateCurrentTimestamp, evaluateRand, executeFunction, executeFunctionFormat, executeFunctionSQL, executeQuery, failureXAErrorCodes, getAlterIdentityColumnSQL, getAlterSequenceSQL, getColumns, getConnectionProperties, getCreateForeignKeyConstraintSQL, getCreateSchemaSQL, getCreateTriggerSQL, getCreateUniqueConstraintSQL, getDropForeignKeyConstraintSQL, getDropSchemaSQL, getDropTriggerSQL, getDropUniqueConstraintSQL, getForeignKeyConstraints, getIdentityColumns, getNextSequenceValueSQL, getPrimaryKey, getSequences, getTables, getTriggerRowAlias, getTruncateTableSQL, getTypes, getUniqueConstraints, indicatesFailure, indicatesFailure, indicatesFailure, indicatesFailure, insertIntoTablePattern, isSelectForUpdate, isValid, locatorPattern, meetsRequirement, parse, parseInsertTable, parseSequence, schemaPattern, sequenceTableType, timeLiteralFormat, timestampLiteralFormat

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

RESERVED_KEY_WORDS

public static final String[] RESERVED_KEY_WORDS

Constructor Detail

PostgreSQLDialect

public PostgreSQLDialect()

Method Detail

vendorPattern

protected String vendorPattern()

Overrides:

vendorPattern in class StandardDialect

See Also:

StandardDialect.vendorPattern()

getDefaultSchemas

public List<String> getDefaultSchemas(DatabaseMetaData metaData)
                               throws SQLException

PostgreSQL uses a schema search path to locate unqualified table names. The default search path is [$user,public], where $user is the current user.

Specified by:

getDefaultSchemas in interface Dialect

Overrides:

getDefaultSchemas in class StandardDialect

Returns:

a list of schema names

Throws:

SQLException

See Also:

StandardDialect.getDefaultSchemas(java.sql.DatabaseMetaData)

getColumnType

public int getColumnType(ColumnProperties properties)

PostgreSQL uses the native type OID to identify BLOBs. However the JDBC driver incomprehensibly maps OIDs to INTEGERs. The PostgreSQL JDBC folks claim this intentional.

Specified by:

getColumnType in interface Dialect

Overrides:

getColumnType in class StandardDialect

Parameters:

properties - table column meta data

Returns:

the JDBC data type of this column

See Also:

StandardDialect.getColumnType(net.sf.hajdbc.ColumnProperties)

identifierPattern

protected Pattern identifierPattern(DatabaseMetaData metaData)
                             throws SQLException

Overrides:

identifierPattern in class StandardDialect

Throws:

SQLException

reservedIdentifiers

protected Set<String> reservedIdentifiers(DatabaseMetaData metaData)

Overrides:

reservedIdentifiers in class StandardDialect

getSequenceSupport

public SequenceSupport getSequenceSupport()

Specified by:

getSequenceSupport in interface Dialect

Overrides:

getSequenceSupport in class StandardDialect

See Also:

StandardDialect.getSequenceSupport()

getIdentityColumnSupport

public IdentityColumnSupport getIdentityColumnSupport()

Specified by:

getIdentityColumnSupport in interface Dialect

Overrides:

getIdentityColumnSupport in class StandardDialect

See Also:

StandardDialect.getIdentityColumnSupport()

truncateTableFormat

protected String truncateTableFormat()

Overrides:

truncateTableFormat in class StandardDialect

See Also:

StandardDialect.truncateTableFormat()

sequencePattern

protected String sequencePattern()

Overrides:

sequencePattern in class StandardDialect

See Also:

StandardDialect.sequencePattern()

nextSequenceValueFormat

protected String nextSequenceValueFormat()

Overrides:

nextSequenceValueFormat in class StandardDialect

See Also:

StandardDialect.nextSequenceValueFormat()

alterIdentityColumnFormat

protected String alterIdentityColumnFormat()

Overrides:

alterIdentityColumnFormat in class StandardDialect

See Also:

StandardDialect.alterIdentityColumnFormat()

currentTimestampPattern

protected String currentTimestampPattern()

Overrides:

currentTimestampPattern in class StandardDialect

See Also:

StandardDialect.currentTimestampPattern()

randomPattern

protected String randomPattern()

Overrides:

randomPattern in class StandardDialect

See Also:

StandardDialect.randomPattern()

selectForUpdatePattern

protected String selectForUpdatePattern()

Recognizes FOR SHARE and FOR UPDATE.

Overrides:

selectForUpdatePattern in class StandardDialect

See Also:

StandardDialect.selectForUpdatePattern()

getDumpRestoreSupport

public DumpRestoreSupport getDumpRestoreSupport()

Specified by:

getDumpRestoreSupport in interface Dialect

Overrides:

getDumpRestoreSupport in class StandardDialect

See Also:

StandardDialect.getDumpRestoreSupport()

dump

public <Z,D extends Database<Z>> void dump(D database,
                                  Decoder decoder,
                                  File file,
                                  boolean dataOnly)
          throws Exception

Specified by:

dump in interface DumpRestoreSupport

Throws:

Exception

restore

public <Z,D extends Database<Z>> void restore(D database,
                                     Decoder decoder,
                                     File file,
                                     boolean dataOnly)
             throws Exception

Specified by:

restore in interface DumpRestoreSupport

Throws:

Exception

getTriggerSupport

public TriggerSupport getTriggerSupport()

Specified by:

getTriggerSupport in interface Dialect

Overrides:

getTriggerSupport in class StandardDialect

See Also:

StandardDialect.getTriggerSupport()

createTriggerFormat

protected String createTriggerFormat()

Overrides:

createTriggerFormat in class StandardDialect

See Also:

StandardDialect.createForeignKeyConstraintFormat()

dropTriggerFormat

protected String dropTriggerFormat()

Overrides:

dropTriggerFormat in class StandardDialect

See Also:

StandardDialect.dropTriggerFormat()