PostgreSQLExecutionFactory (Teiid 8.6.0.Final API)

java.lang.Object
- org.teiid.translator.ExecutionFactory<DataSource,Connection>
- - org.teiid.translator.jdbc.JDBCExecutionFactory
  - - org.teiid.translator.jdbc.postgresql.PostgreSQLExecutionFactory

Direct Known Subclasses:: GreenplumExecutionFactory

@Translator(name="postgresql",
            description="A translator for postgreSQL Database")
public class PostgreSQLExecutionFactory
extends JDBCExecutionFactory

Translator class for PostgreSQL. Updated to expect a 8.0+ jdbc client

Since:: 4.3

Nested Class Summary
- Nested classes/interfaces inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory
  JDBCExecutionFactory.StructRetrieval
- Nested classes/interfaces inherited from class org.teiid.translator.ExecutionFactory
  ExecutionFactory.Format, ExecutionFactory.NullOrder, ExecutionFactory.SupportedJoinCriteria

Field Summary

Fields
Modifier and Type	Field and Description
`static Version`	`EIGHT_0`
`static Version`	`EIGHT_1`
`static Version`	`EIGHT_2`
`static Version`	`EIGHT_3`
`static Version`	`EIGHT_4`
`static Version`	`NINE_0`

Fields inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory
DEFAULT_MAX_DEPENDENT_PREDICATES, DEFAULT_MAX_IN_CRITERIA, DEFAULT_TIME_ZONE, dialect

Fields inherited from class org.teiid.translator.ExecutionFactory
DEFAULT_MAX_FROM_GROUPS, DEFAULT_MAX_IN_CRITERIA_SIZE

Constructor Summary

Constructors
Constructor and Description

PostgreSQLExecutionFactory()

Constructors
Constructor and Description
`PostgreSQLExecutionFactory()`

Method Summary

Methods
Modifier and Type	Method and Description
`static List<Object>`	`addDefaultEscape(Like like)` Add a default escape
`String`	`getCreateTemporaryTablePostfix(boolean inTransaction)`
`ExecutionFactory.NullOrder`	`getDefaultNullOrder()` Returns the default null ordering
`String`	`getHibernateDialectClassName()`
`List<String>`	`getSupportedFunctions()` Get list of all supported function names.
`int`	`getTimestampNanoPrecision()` Return the precision of timestamp literals.
`void`	`loadedTemporaryTable(String tableName, ExecutionContext context, Connection connection)` pg needs to collect stats for effective planning
`void`	`start()` Initialize the connector with supplied configuration
`boolean`	`supportsAggregatesEnhancedNumeric()` Support indicates connector can accept STDDEV_POP, STDDEV_VAR, VAR_POP, VAR_SAMP
`boolean`	`supportsArrayAgg()`
`boolean`	`supportsArrayType()` The engine currently uses array types for dependent joins.
`boolean`	`supportsCommonTableExpressions()`
`boolean`	`supportsElementaryOlapOperations()`
`boolean`	`supportsExcept()` Support indicates that the connector supports the EXCEPT of two queries.
`boolean`	`supportsFormatLiteral(String literal, ExecutionFactory.Format format)`
`boolean`	`supportsInlineViews()` This is true only after Postgre version 7.1 However, since version 7 was released in 2000 we'll assume a post 7 instance.
`boolean`	`supportsIntersect()` Support indicates that the connector supports the INTERSECT of two queries.
`boolean`	`supportsLikeRegex()`
`boolean`	`supportsOnlyFormatLiterals()` See also `ExecutionFactory.supportsFormatLiteral(String, Format)`
`boolean`	`supportsOrderByNullOrdering()` Returns whether the database supports explicit null ordering.
`boolean`	`supportsRowLimit()` Gets whether the connector can limit the number of rows returned by a query.
`boolean`	`supportsRowOffset()` Gets whether the connector supports a SQL clause (similar to the LIMIT with an offset) that can return result sets that start in the middle of the resulting rows returned by a query
`boolean`	`supportsSelectWithoutFrom()`
`boolean`	`supportsSimilarTo()`
`boolean`	`supportsStringAgg()`
`boolean`	`supportsWindowDistinctAggregates()`
`List<?>`	`translate(LanguageObject obj, ExecutionContext context)` Postgres doesn't provide min/max(boolean), so this conversion writes a min(BooleanValue) as bool_and(BooleanValue)
`List<?>`	`translateLimit(Limit limit, ExecutionContext context)` Return a List of translated parts (`LanguageObject`s and Objects), or null if to rely on the default translation.
`String`	`translateLiteralBoolean(Boolean booleanValue)` Subclasses should override this method to provide a different sql translation of the literal boolean value.
`String`	`translateLiteralDate(Date dateValue)` Subclasses should override this method to provide a different sql translation of the literal date value.
`String`	`translateLiteralTime(Time timeValue)` Subclasses should override this method to provide a different sql translation of the literal time value.
`String`	`translateLiteralTimestamp(Timestamp timestampValue)` Subclasses should override this method to provide a different sql translation of the literal timestamp value.
`protected boolean`	`usesDatabaseVersion()`

Methods inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory
addSourceComment, afterInitialConnectionObtained, bindValue, closeConnection, convertObject, createDirectExecution, createMetadataProcessor, createProcedureExecution, createResultSetExecution, createTempTable, createUpdateExecution, executeStoredProcedure, formatDateValue, getConnection, getCreateTemporaryTableString, getCreateTempTableSQL, getDatabaseCalendar, getDatabaseTimeZone, getDatabaseVersion, getDefaultSupportedFunctions, getDialect, getFunctionModifiers, getLikeRegexString, getMaxPreparedInsertBatchSize, getMetadata, getSetOperationString, getSourceComment, getSQLConversionVisitor, getStructRetrieval, getTemporaryTableName, getVersion, hasTimeType, initCapabilities, isEnableDependentJoins, isSourceRequired, isSourceRequiredForCapabilities, isTrimStrings, obtainedConnection, parseName, registerFunctionModifier, registerSpecificTypeOfOutParameter, replaceElementName, retrieveValue, retrieveValue, setDatabaseTimeZone, setDatabaseVersion, setDatabaseVersion, setEnableDependentJoins, setFetchSize, setMaxPreparedInsertBatchSize, setStructRetrieval, setTrimStrings, setUseBindVariables, setUseCommentsInSourceQuery, supportsAggregatesAvg, supportsAggregatesCount, supportsAggregatesCountStar, supportsAggregatesDistinct, supportsAggregatesMax, supportsAggregatesMin, supportsAggregatesSum, supportsAliasedTable, supportsBatchedUpdates, supportsBulkUpdate, supportsCompareCriteriaEquals, supportsCompareCriteriaOrdered, supportsCorrelatedSubqueries, supportsDependentJoins, supportsExistsCriteria, supportsFullDependentJoins, supportsGeneratedKeys, supportsGeneratedKeys, supportsGroupBy, supportsHaving, supportsInCriteria, supportsInCriteriaSubquery, supportsInsertWithQueryExpression, supportsIsNullCriteria, supportsLikeCriteria, supportsLikeCriteriaEscapeCharacter, supportsNotCriteria, supportsOrCriteria, supportsOrderByUnrelated, supportsQuantifiedCompareCriteriaAll, supportsQuantifiedCompareCriteriaSome, supportsScalarSubqueries, supportsSearchedCaseExpressions, supportsSelectExpression, supportsSelfJoins, supportsSetQueryOrderBy, supportsUnions, tempTableRequiresTransaction, translateCommand, useAsInGroupAlias, useBindVariables, useCommentsInSourceQuery, useParensForJoins, useParensForSetQueries, usePreparedStatements, useSelectLimit, useStreamsForLobs, useWithRollup

Methods inherited from class org.teiid.translator.ExecutionFactory
addPushDownFunction, areLobsUsableAfterClose, createExecution, getCacheDirective, getConnection, getDirectQueryProcedureName, getInstance, getLanguageFactory, getMaxDependentInPredicates, getMaxFromGroups, getMaxInCriteriaSize, getNativeQueryProcedureName, getPushDownFunctions, getSupportedJoinCriteria, getTypeFacility, isCopyLobs, isForkable, isImmutable, isSourceRequiredForMetadata, isThreadBound, requiresCriteria, setCopyLobs, setDirectQueryProcedureName, setImmutable, setMaxDependentInPredicates, setMaxInCriteriaSize, setNativeQueryProcedureName, setRequiresCriteria, setSourceRequired, setSourceRequiredForMetadata, setSupportedJoinCriteria, setSupportsDirectQueryProcedure, setSupportsFullOuterJoins, setSupportsInnerJoins, setSupportsNativeQueries, setSupportsOrderBy, setSupportsOuterJoins, setSupportsSelectDistinct, setThreadBound, supportsAdvancedOlapOperations, supportsConvert, supportsDirectQueryProcedure, supportsFullOuterJoins, supportsFunctionsInGroupBy, supportsGroupByRollup, supportsInnerJoins, supportsNativeQueries, supportsOnlyCorrelatedSubqueries, supportsOnlyLiteralComparison, supportsOnlySingleTableGroupBy, supportsOrderBy, supportsOrderByWithExtendedGrouping, supportsOuterJoins, supportsSelectDistinct, supportsSubqueryInOn, supportsWindowOrderByWithAggregates, useAnsiJoin

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

- Field Detail
  - EIGHT_0
```
public static final Version EIGHT_0
```
  - EIGHT_1
```
public static final Version EIGHT_1
```
  - EIGHT_2
```
public static final Version EIGHT_2
```
  - EIGHT_3
```
public static final Version EIGHT_3
```
  - EIGHT_4
```
public static final Version EIGHT_4
```
  - NINE_0
```
public static final Version NINE_0
```
- Constructor Detail
  - PostgreSQLExecutionFactory
```
public PostgreSQLExecutionFactory()
```
- Method Detail
  - start
```
public void start()
           throws TranslatorException
```
    Description copied from class: ExecutionFactory
    
    Initialize the connector with supplied configuration
    
    Overrides:
    
    start in class JDBCExecutionFactory
    
    Throws:
    
    TranslatorException
  - translateLiteralBoolean
```
public String translateLiteralBoolean(Boolean booleanValue)
```
    Description copied from class: JDBCExecutionFactory
    
    Subclasses should override this method to provide a different sql translation of the literal boolean value. By default, a boolean literal is represented as: '0' or '1'.
    
    Overrides:
    
    translateLiteralBoolean in class JDBCExecutionFactory
    
    Parameters:
    booleanValue - Boolean value, never null
    
    Returns:
    Translated string
  - translateLiteralDate
```
public String translateLiteralDate(Date dateValue)
```
    Description copied from class: JDBCExecutionFactory
    
    Subclasses should override this method to provide a different sql translation of the literal date value. By default, a date literal is represented as: {d '2002-12-31'}
    
    Overrides:
    
    translateLiteralDate in class JDBCExecutionFactory
    
    Parameters:
    dateValue - Date value, never null
    
    Returns:
    Translated string
  - translateLiteralTime
```
public String translateLiteralTime(Time timeValue)
```
    Description copied from class: JDBCExecutionFactory
    
    Subclasses should override this method to provide a different sql translation of the literal time value. By default, a time literal is represented as: {t '23:59:59'} See JDBCExecutionFactory.hasTimeType() to represent literal times as timestamps.
    
    Overrides:
    
    translateLiteralTime in class JDBCExecutionFactory
    
    Parameters:
    timeValue - Time value, never null
    
    Returns:
    Translated string
  - translateLiteralTimestamp
```
public String translateLiteralTimestamp(Timestamp timestampValue)
```
    Description copied from class: JDBCExecutionFactory
    
    Subclasses should override this method to provide a different sql translation of the literal timestamp value. By default, a timestamp literal is represented as: {ts '2002-12-31 23:59:59'}. See JDBCExecutionFactory.getTimestampNanoPrecision() to control the literal precision.
    
    Overrides:
    
    translateLiteralTimestamp in class JDBCExecutionFactory
    
    Parameters:
    timestampValue - Timestamp value, never null
    
    Returns:
    Translated string
  - getTimestampNanoPrecision
```
public int getTimestampNanoPrecision()
```
    Description copied from class: JDBCExecutionFactory
    
    Return the precision of timestamp literals. Defaults to 9.
    
    Overrides:
    
    getTimestampNanoPrecision in class JDBCExecutionFactory
    
    Returns:
    digits of timestamp nano precision.
  - translateLimit
```
public List<?> translateLimit(Limit limit,
                     ExecutionContext context)
```
    Description copied from class: JDBCExecutionFactory
    
    Return a List of translated parts (LanguageObjects and Objects), or null if to rely on the default translation.
    
    Overrides:
    
    translateLimit in class JDBCExecutionFactory
    
    Returns:
    a list of translated parts
  - translate
```
public List<?> translate(LanguageObject obj,
                ExecutionContext context)
```
    Postgres doesn't provide min/max(boolean), so this conversion writes a min(BooleanValue) as bool_and(BooleanValue)
    
    Overrides:
    
    translate in class JDBCExecutionFactory
    
    Returns:
    list of translated parts
    Since:
    
    4.3
    
    See Also:
    LanguageObjectVisitor.visit(org.teiid.language.AggregateFunction)
  - addDefaultEscape
```
public static List<Object> addDefaultEscape(Like like)
```
    Add a default escape
    
    Parameters:
    like -
    
    Returns:
  - getDefaultNullOrder
```
public ExecutionFactory.NullOrder getDefaultNullOrder()
```
    Description copied from class: ExecutionFactory
    
    Returns the default null ordering
    
    Overrides:
    
    getDefaultNullOrder in class JDBCExecutionFactory
    
    Returns:
    the ExecutionFactory.NullOrder
  - supportsOrderByNullOrdering
```
public boolean supportsOrderByNullOrdering()
```
    Description copied from class: ExecutionFactory
    
    Returns whether the database supports explicit null ordering.
    
    Overrides:
    
    supportsOrderByNullOrdering in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if nulls first/last can be specified
  - getSupportedFunctions
```
public List<String> getSupportedFunctions()
```
    Description copied from class: ExecutionFactory
    
    Get list of all supported function names. Arithmetic functions have names like "+".
    
    Overrides:
    
    getSupportedFunctions in class JDBCExecutionFactory
    
    See Also:
    for a listing of system pushdown functions. Note that not all system functions are listed as some functions will use a common name such as CONCAT vs. the || operator, and other functions will be rewritten and not pushed down, such as SPACE. Note: User defined functions should be specified fully qualified.
  - supportsInlineViews
```
public boolean supportsInlineViews()
```
    This is true only after Postgre version 7.1 However, since version 7 was released in 2000 we'll assume a post 7 instance.
    
    Overrides:
    
    supportsInlineViews in class JDBCExecutionFactory
  - supportsRowLimit
```
public boolean supportsRowLimit()
```
    Description copied from class: ExecutionFactory
    
    Gets whether the connector can limit the number of rows returned by a query.
    
    Overrides:
    
    supportsRowLimit in class ExecutionFactory<DataSource,Connection>
  - supportsRowOffset
```
public boolean supportsRowOffset()
```
    Description copied from class: ExecutionFactory
    
    Gets whether the connector supports a SQL clause (similar to the LIMIT with an offset) that can return result sets that start in the middle of the resulting rows returned by a query
    
    Overrides:
    
    supportsRowOffset in class ExecutionFactory<DataSource,Connection>
  - supportsExcept
```
public boolean supportsExcept()
```
    Description copied from class: ExecutionFactory
    
    Support indicates that the connector supports the EXCEPT of two queries.
    
    Overrides:
    
    supportsExcept in class ExecutionFactory<DataSource,Connection>
  - supportsIntersect
```
public boolean supportsIntersect()
```
    Description copied from class: ExecutionFactory
    
    Support indicates that the connector supports the INTERSECT of two queries.
    
    Overrides:
    
    supportsIntersect in class ExecutionFactory<DataSource,Connection>
  - supportsAggregatesEnhancedNumeric
```
public boolean supportsAggregatesEnhancedNumeric()
```
    Description copied from class: ExecutionFactory
    
    Support indicates connector can accept STDDEV_POP, STDDEV_VAR, VAR_POP, VAR_SAMP
    
    Overrides:
    
    supportsAggregatesEnhancedNumeric in class ExecutionFactory<DataSource,Connection>
  - supportsCommonTableExpressions
```
public boolean supportsCommonTableExpressions()
```
    Overrides:
    
    supportsCommonTableExpressions in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if the WITH clause is supported
  - supportsArrayAgg
```
public boolean supportsArrayAgg()
```
    Overrides:
    
    supportsArrayAgg in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if array_agg is supported
  - supportsElementaryOlapOperations
```
public boolean supportsElementaryOlapOperations()
```
    Overrides:
    
    supportsElementaryOlapOperations in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if Elementary OLAP operations are supported including window functions and inline window specifications that include simple expressions in partitioning and ordering
  - supportsWindowDistinctAggregates
```
public boolean supportsWindowDistinctAggregates()
```
    Overrides:
    
    supportsWindowDistinctAggregates in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if distinct aggregates can be windowed function.
  - supportsSimilarTo
```
public boolean supportsSimilarTo()
```
    Overrides:
    
    supportsSimilarTo in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if the SIMILAR TO predicate is supported
  - supportsLikeRegex
```
public boolean supportsLikeRegex()
```
    Overrides:
    
    supportsLikeRegex in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if the LIKE_REGEX predicate is supported
  - supportsOnlyFormatLiterals
```
public boolean supportsOnlyFormatLiterals()
```
    Description copied from class: ExecutionFactory
    
    See also ExecutionFactory.supportsFormatLiteral(String, Format)
    
    Overrides:
    
    supportsOnlyFormatLiterals in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if only literal formats are supports.
  - supportsFormatLiteral
```
public boolean supportsFormatLiteral(String literal,
                            ExecutionFactory.Format format)
```
    Overrides:
    
    supportsFormatLiteral in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if the given Java format string is supported
  - supportsArrayType
```
public boolean supportsArrayType()
```
    Description copied from class: ExecutionFactory
    
    The engine currently uses array types for dependent joins.
    
    Overrides:
    
    supportsArrayType in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if an array type is supported.
  - usesDatabaseVersion
```
protected boolean usesDatabaseVersion()
```
    Overrides:
    
    usesDatabaseVersion in class JDBCExecutionFactory
  - supportsStringAgg
```
public boolean supportsStringAgg()
```
    Overrides:
    
    supportsStringAgg in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if string_agg is supported
  - supportsSelectWithoutFrom
```
public boolean supportsSelectWithoutFrom()
```
    Overrides:
    
    supportsSelectWithoutFrom in class ExecutionFactory<DataSource,Connection>
    
    Returns:
    true if the translator support SELECT without a FROM clause
  - getHibernateDialectClassName
```
public String getHibernateDialectClassName()
```
    Overrides:
    
    getHibernateDialectClassName in class JDBCExecutionFactory
  - getCreateTemporaryTablePostfix
```
public String getCreateTemporaryTablePostfix(boolean inTransaction)
```
    Overrides:
    
    getCreateTemporaryTablePostfix in class JDBCExecutionFactory
    
    Returns:
    the post script for the temp table create
  - loadedTemporaryTable
```
public void loadedTemporaryTable(String tableName,
                        ExecutionContext context,
                        Connection connection)
                          throws SQLException
```
    pg needs to collect stats for effective planning
    
    Overrides:
    
    loadedTemporaryTable in class JDBCExecutionFactory
    
    Throws:
    
    SQLException

Class PostgreSQLExecutionFactory

Nested Class Summary

Nested classes/interfaces inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

Nested classes/interfaces inherited from class org.teiid.translator.ExecutionFactory

Field Summary

Fields inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

Fields inherited from class org.teiid.translator.ExecutionFactory

Constructor Summary

Method Summary

Methods inherited from class org.teiid.translator.jdbc.JDBCExecutionFactory

Methods inherited from class org.teiid.translator.ExecutionFactory

Methods inherited from class java.lang.Object

Field Detail

EIGHT_0

EIGHT_1

EIGHT_2

EIGHT_3

EIGHT_4

NINE_0

Constructor Detail

PostgreSQLExecutionFactory

Method Detail

start

translateLiteralBoolean

translateLiteralDate

translateLiteralTime

translateLiteralTimestamp

getTimestampNanoPrecision

translateLimit

translate

addDefaultEscape

getDefaultNullOrder

supportsOrderByNullOrdering

getSupportedFunctions

supportsInlineViews

supportsRowLimit

supportsRowOffset

supportsExcept

supportsIntersect

supportsAggregatesEnhancedNumeric

supportsCommonTableExpressions

supportsArrayAgg

supportsElementaryOlapOperations

supportsWindowDistinctAggregates

supportsSimilarTo

supportsLikeRegex

supportsOnlyFormatLiterals

supportsFormatLiteral

supportsArrayType

usesDatabaseVersion

supportsStringAgg

supportsSelectWithoutFrom

getHibernateDialectClassName

getCreateTemporaryTablePostfix

loadedTemporaryTable