org.jumpmind.symmetric.db.postgresql
Class PostgreSqlDbDialect

java.lang.Object
  org.jumpmind.symmetric.db.AbstractDbDialect
      org.jumpmind.symmetric.db.postgresql.PostgreSqlDbDialect

All Implemented Interfaces:

IDbDialect

public class PostgreSqlDbDialect
extends AbstractDbDialect
implements IDbDialect

Field Summary

protected java.lang.String

defaultSchema

Fields inherited from class org.jumpmind.symmetric.db.AbstractDbDialect

cachedModel, jdbcTemplate, MAX_SYMMETRIC_SUPPORTED_TRIGGER_SIZE, platform, sqlErrorTranslator, sqlTemplate, tablePrefix, transactionTemplate

Constructor Summary

PostgreSqlDbDialect()

Method Summary

protected boolean	allowsNullForIdentityColumn()
void	disableSyncTriggers(java.lang.String nodeId)
protected boolean	doesTriggerExistOnPlatform(java.lang.String catalogName, java.lang.String schema, java.lang.String tableName, java.lang.String triggerName)
void	enableSyncTriggers()
BinaryEncoding	getBinaryEncoding()
java.lang.String	getDefaultCatalog()
java.lang.String	getDefaultSchema()
java.lang.String	getSelectLastInsertIdSql(java.lang.String sequenceName)
java.lang.String	getSyncTriggersExpression()
java.lang.String	getTransactionTriggerExpression(Trigger trigger)
protected void	initForSpecificDialect()
boolean	isCharSpacePadded()
boolean	isCharSpaceTrimmed()
boolean	isEmptyStringNulled()
void	purge() Implement this if the database has some type of cleanup functionality that needs to be run when dropping database objects.
void	removeTrigger(java.lang.String schemaName, java.lang.String triggerName)
void	removeTrigger(java.lang.String catalogName, java.lang.String schemaName, java.lang.String triggerName, java.lang.String tableName, TriggerHistory oldHistory)
boolean	requiresSavepointForFallback()
boolean	storesLowerCaseNamesInCatalog()
boolean	supportsTransactionId()

Methods inherited from class org.jumpmind.symmetric.db.AbstractDbDialect

addPrefixAndCreateTablesIfNecessary, cleanupAfterDataLoad, createCsvDataSql, createCsvPrimaryKeySql, createInitalLoadSqlFor, createPostTriggerDDL, createPurgeSqlFor, createRequiredFunctions, createSavepoint, createSavepointForFallback, createTables, determineAutoIncrementFromResultSetMetaData, disableSyncTriggers, doesDatabaseNeedConfigured, doesTriggerExist, findTable, fixForeignKeys, getConfigDdlDatabase, getConfigDdlXml, getCreateSymmetricDDL, getCreateTableSQL, getCreateTableXML, getDatabaseColumnFilter, getEngineName, getIdentifierQuoteString, getJdbcTemplate, getMajorVersion, getMaxTriggerNameLength, getMetaDataFor, getMetaDataFor, getMinorVersion, getName, getPlatform, getProductVersion, getSequenceName, getSqlErrorTranslator, getStreamingResultsFetchSize, getTablePrefix, getTriggerName, getVersion, init, initColumnsForColumn, initColumnsForIndex, initColumnsForPK, initColumnsForTable, initConfigDb, initTrigger, insertWithGeneratedKey, insertWithGeneratedKey, isBlobOverrideToBinary, isBlobSyncSupported, isClobSyncSupported, isDateOverrideToTimestamp, isTransactionIdOverrideSupported, makeAllColumnsPrimaryKeysIfNoPrimaryKeysFound, prefixConfigDatabase, prepareTableForDataLoad, readColumn, readColumns, readColumns, readIndex, readIndices, readPrimaryKeyName, readPrimaryKeyNames, readTable, releaseSavepoint, replaceTemplateVariables, rollbackToSavepoint, setParameterService, setSqlTemplate, setStreamingResultsFetchSize, setTablePrefix, setTransactionTemplate, storesUpperCaseNamesInCatalog, supportsGetGeneratedKeys, switchCatalogForTriggerInstall

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.jumpmind.symmetric.db.IDbDialect

cleanupAfterDataLoad, createCsvDataSql, createCsvPrimaryKeySql, createInitalLoadSqlFor, createPurgeSqlFor, createSavepoint, createSavepointForFallback, createTables, disableSyncTriggers, doesDatabaseNeedConfigured, doesTriggerExist, getCreateSymmetricDDL, getCreateTableSQL, getCreateTableXML, getDatabaseColumnFilter, getEngineName, getIdentifierQuoteString, getJdbcTemplate, getMajorVersion, getMaxTriggerNameLength, getMetaDataFor, getMetaDataFor, getMinorVersion, getName, getPlatform, getProductVersion, getSqlErrorTranslator, getStreamingResultsFetchSize, getTablePrefix, getTriggerName, getVersion, initConfigDb, initTrigger, insertWithGeneratedKey, insertWithGeneratedKey, isBlobOverrideToBinary, isBlobSyncSupported, isClobSyncSupported, isDateOverrideToTimestamp, isTransactionIdOverrideSupported, prepareTableForDataLoad, releaseSavepoint, replaceTemplateVariables, rollbackToSavepoint, storesUpperCaseNamesInCatalog

Field Detail

defaultSchema

protected java.lang.String defaultSchema

Constructor Detail

PostgreSqlDbDialect

public PostgreSqlDbDialect()

Method Detail

initForSpecificDialect

protected void initForSpecificDialect()

Specified by:

initForSpecificDialect in class AbstractDbDialect

doesTriggerExistOnPlatform

protected boolean doesTriggerExistOnPlatform(java.lang.String catalogName,
                                             java.lang.String schema,
                                             java.lang.String tableName,
                                             java.lang.String triggerName)

Specified by:

doesTriggerExistOnPlatform in class AbstractDbDialect

removeTrigger

public void removeTrigger(java.lang.String schemaName,
                          java.lang.String triggerName)

removeTrigger

public void removeTrigger(java.lang.String catalogName,
                          java.lang.String schemaName,
                          java.lang.String triggerName,
                          java.lang.String tableName,
                          TriggerHistory oldHistory)

Specified by:

removeTrigger in interface IDbDialect

disableSyncTriggers

public void disableSyncTriggers(java.lang.String nodeId)

Specified by:

disableSyncTriggers in interface IDbDialect

enableSyncTriggers

public void enableSyncTriggers()

Specified by:

enableSyncTriggers in interface IDbDialect

getSyncTriggersExpression

public java.lang.String getSyncTriggersExpression()

Specified by:

getSyncTriggersExpression in interface IDbDialect

getTransactionTriggerExpression

public java.lang.String getTransactionTriggerExpression(Trigger trigger)

Specified by:

getTransactionTriggerExpression in interface IDbDialect

Overrides:

getTransactionTriggerExpression in class AbstractDbDialect

getSelectLastInsertIdSql

public java.lang.String getSelectLastInsertIdSql(java.lang.String sequenceName)

Specified by:

getSelectLastInsertIdSql in interface IDbDialect

Overrides:

getSelectLastInsertIdSql in class AbstractDbDialect

requiresSavepointForFallback

public boolean requiresSavepointForFallback()

Specified by:

requiresSavepointForFallback in interface IDbDialect

Overrides:

requiresSavepointForFallback in class AbstractDbDialect

isCharSpacePadded

public boolean isCharSpacePadded()

Specified by:

isCharSpacePadded in interface IDbDialect

isCharSpaceTrimmed

public boolean isCharSpaceTrimmed()

Specified by:

isCharSpaceTrimmed in interface IDbDialect

isEmptyStringNulled

public boolean isEmptyStringNulled()

Specified by:

isEmptyStringNulled in interface IDbDialect

storesLowerCaseNamesInCatalog

public boolean storesLowerCaseNamesInCatalog()

Specified by:

storesLowerCaseNamesInCatalog in interface IDbDialect

Overrides:

storesLowerCaseNamesInCatalog in class AbstractDbDialect

allowsNullForIdentityColumn

protected boolean allowsNullForIdentityColumn()

Overrides:

allowsNullForIdentityColumn in class AbstractDbDialect

supportsTransactionId

public boolean supportsTransactionId()

Specified by:

supportsTransactionId in interface IDbDialect

Overrides:

supportsTransactionId in class AbstractDbDialect

purge

public void purge()

Description copied from interface: IDbDialect

Implement this if the database has some type of cleanup functionality that needs to be run when dropping database objects. An example is Oracle's 'purge recyclebin'

Specified by:

purge in interface IDbDialect

getDefaultCatalog

public java.lang.String getDefaultCatalog()

Specified by:

getDefaultCatalog in interface IDbDialect

getDefaultSchema

public java.lang.String getDefaultSchema()

Specified by:

getDefaultSchema in interface IDbDialect

getBinaryEncoding

public BinaryEncoding getBinaryEncoding()

Specified by:

getBinaryEncoding in interface IDbDialect

Overrides:

getBinaryEncoding in class AbstractDbDialect