P2JPostgreSQLDialect (P2J - Progress 4GL to Java Conversion and Runtime)

java.lang.Object
- com.goldencode.p2j.persist.dialect.Dialect
- - com.goldencode.p2j.persist.dialect.P2JPostgreSQLDialect

```
public class P2JPostgreSQLDialect
extends Dialect
```
Extends Hibernate's PostgreSQLDialect class to add method implementations required by the abstract Dialect base class.
Note: this implementation expects a directory to be available at the time the class is loaded.

Nested Class Summary

Nested Classes
Modifier and Type	Class and Description
`private static class`	`P2JPostgreSQLDialect.Aggregator`
`private static class`	`P2JPostgreSQLDialect.Context` Context local data needed by this object to perform dialect-specific processing.
`private static class`	`P2JPostgreSQLDialect.FWDBlob` Read-only implementation of a BLOB instance, to be used by the JDBC driver.
`private static class`	`P2JPostgreSQLDialect.FWDClob` Read-only implementation of a CLOB instance, to be used by the JDBC driver.
`static class`	`P2JPostgreSQLDialect.PgScriptSplitter` Splitter for DDL scripts.
`static class`	`P2JPostgreSQLDialect.UDF_TYPE` UDF types

Nested classes/interfaces inherited from class com.goldencode.p2j.persist.dialect.Dialect
Dialect.WeightAggregator

Field Summary

Fields
Modifier and Type	Field and Description
`private static java.util.List<java.lang.String>`	`AFTER_INSERT_TRIGGER` AFTER INSERT trigger for words tables' support template
`private static java.util.List<java.lang.String>`	`AFTER_UPDATE_TRIGGER` AFTER UPDATE trigger for words tables' support template
`private static boolean`	`debug` Debug level logging enabled?
`private static int`	`DEFAULT_VACUUM_INTERVAL` Default minimum interval in seconds between temp table vacuums
`private static java.lang.String`	`DROP_TRIGGER` DROP TRIGGER statement
`private static java.util.Map<java.lang.String,java.lang.String>`	`fwd2sql` Mapping between the FWD possible field/column types and their SQL counterparts.
`private static java.sql.Date`	`highDate` Highest date supported by PostgreSQL (12/31/32767 AD)
`private static java.lang.ThreadLocal<java.lang.Boolean>`	`inlineLimit` Flag indicating whether to inline a record limit in an SQL SELECT
`private static java.util.List<java.lang.String>`	`INS_TRIGGER_FUNC_CEXT` ON INSERT trigger function for words tables' support template (custom extent field)
`private static java.lang.String`	`INS_TRIGGER_LINE` Repeatable line template for the ON INSERT trigger function for words tables' support template (custom extent field)
`private static CentralLogger`	`LOG` Logger
`private static java.sql.Date`	`lowDate` Lowest date supported by PostgreSQL (01/01/4713 BC)
`private static java.lang.String`	`PK` Name of the primary key column.
`private static java.util.List<java.lang.String>`	`TRIGGER_FUNC` trigger function for words tables' support template
`private static java.util.List<java.lang.String>`	`TRIGGER_FUNC_CEXT` trigger function for words tables' support template (custom extent field)
`private static java.util.List<java.lang.String>`	`TRIGGER_FUNC_EXT` trigger function for words tables' support template (extent field)
`private static java.util.regex.Pattern`	`UDF_ERROR_MESSAGE` Regex Pattern for parsing message cased by error raised by UDF.
`private static boolean`	`useCte4Contains` Allow runtime switch between using CTE for word tables and IN (SELECT ...)
`private static boolean`	`useMixedMode4Contains` Allow runtime switch between 'pure' CTE mode and a 'mixed' one
`private static boolean`	`useUdf4Contains` Allow runtime switch between word tables and UDF
`private static long`	`vacuumInterval` Actual minimum interval in milliseconds between temp table vacuums
`private static Dialect.WeightAggregator`	`WEIGHT_AGGREGATOR` Weights' aggregator

Fields inherited from class com.goldencode.p2j.persist.dialect.Dialect
CASE_TYPE_TOK, DEFAULT_MAX_WIDTH, SCALE_TOK

Constructor Summary

Constructors
Constructor and Description

P2JPostgreSQLDialect()
Default constructor.

Constructors
Constructor and Description
`P2JPostgreSQLDialect()` Default constructor.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addRtrimmedExpression(java.lang.String expr, java.lang.StringBuilder sb)` Composes a rtrim equivalent call for a specified expr.
`java.sql.Blob`	`blobCreator(java.sql.Connection conn, byte[] bytes)` Create a `Blob` instance from the specified bytes.
`java.lang.String`	`buildRemoteURL(java.lang.String url, Database database)` Build the URL to be used for a remote connection, based on the given URL and database.
`java.sql.Clob`	`clobCreator(java.sql.Connection conn, java.lang.String value)` Create a `Clob` instance from the specified value.
`java.lang.Class<? extends com.mchange.v2.c3p0.AbstractConnectionCustomizer>`	`connectionCustomizer(DatabaseConfig cfg)` Get c3p0 ConnectionCustomizer class for the dialect.
`java.lang.Object`	`createContext(Persistence persistence)` Create a data object, the purpose of which is specific to a particular dialect implementation, to be stored as a context-local object.
`SequenceHandler`	`createSequenceHandler(java.lang.String ldbName)` Creates and returns a `SequenceHandler` for a PostgresSQL database.
`ErrorManager.ErrorEntry`	`errorEntry(java.lang.String message)` Create the error descriptor from the SQLException message
`boolean`	`explicitSetCollation()` Check if the dialect needs to set an explicit collation during schema DDL generation.
`java.lang.String`	`extractColumnName(java.lang.String expr)` Given a column expression as queried from database metadata, extract the root name of a column.
`java.lang.String`	`formatDate(date d)` Format a date object as a string which is appropriate for use in an SQL statement.
`void`	`generateWordTablesDDLImpl(java.lang.String dbName, java.io.PrintStream out, java.lang.String eoln, java.util.Collection<WordTable> wordTables)` Worker method for `generateTriggerDDLs()`.
`java.lang.String`	`getAnalyzeString(java.lang.String table)` Construct and return a string which represents the `analyze` or similar statements for this dialect.
`java.lang.String`	`getCatalogPattern(Database database)` Provides catalog matching pattern to load data correctly from JDBC.
`java.lang.String`	`getCodepage(java.sql.Connection conn)` Use the provided database connection to extract the codepage/CharSet used by the database and report it back to the caller.
`java.lang.String`	`getCollation(java.sql.Connection conn)` Use the provided database connection to extract the collation used by the database and report it back to the caller.
`java.lang.String`	`getComputedColumnFormula(java.lang.String colName, boolean ignoreCase)` Returns the formula for character computed columns.
`java.lang.String`	`getComputedColumnString(java.lang.String name, java.lang.String type, int scale, boolean cs)` Constructs and returns the declaration of a computed column based on its name, type, scale, and case-sensitiveness.
`java.lang.String`	`getCreateSequenceString(java.lang.String name)` Generate a DDL string which will create a global sequence.
`java.lang.String`	`getCreateSequenceString(java.lang.String name, long start)` Generate a DDL string which will create a global sequence with the given starting value.
`java.lang.String`	`getCreateSequenceString(java.lang.String name, java.lang.Long init, java.lang.Long increment, java.lang.Long minVal, java.lang.Long maxVal, java.lang.Boolean cycle)` Generate a DDL string which will create a sequence with given properties.
`java.lang.String`	`getCreateTemporaryTablePostfix(boolean noUndo)` Return the ending of the DDL statement that creates a temporary table.
`java.lang.String`	`getCreateTemporaryTableString(boolean ifNotExist)` Return the beginning of the DDL statement that creates a temporary table.
`java.util.List<java.lang.String>`	`getDatabasePrepareStatements(Database database)` Get a list of database prepare DDL statements.
`java.lang.String`	`getDelimiter()` Get the statement delimiter for this dialect.
`java.lang.String`	`getDriverClassName()` Get the name of the JDBC driver class associated with this dialect.
`java.lang.String`	`getDropIndexString(boolean ifExists, java.lang.String idxName, java.lang.String tableName)` Obtain a DDL statement which drops a SQL index.
`java.lang.String`	`getDropIndexString(P2JIndex index)` Build the DDL to drop an index based upon the specified definition.
`java.lang.String`	`getDropSequenceString(java.lang.String name)` Generate a DDL string which will drop a sequence.
`java.lang.String`	`getDropTableString(boolean ifExists, java.lang.String tableName)` Obtain a DDL statement which drops a SQL table.
`java.sql.Date`	`getHighDate()` Retrieve the latest possible date value which is valid for the backing database.
`int`	`getIndexLengthLimit()` Some dialects do have constraints about the maximum size of fields that compose an index.
`java.lang.String`	`getJdbcDatabaseType()` Get the name of the JDBC database type (as in JBC URL).
`java.lang.String`	`getLimitString(java.lang.String sql, int offset, int limit)` Override the parent's implementation to inline small (2 or less) limit values when there is no accompanying offset.
`java.sql.Date`	`getLowDate()` Retrieve the earliest possible date value which is valid for the backing database.
`int`	`getMaxEntriesInSelect()` Returns the max numbers of fields selected that the dialect can allow without throwing an error.
`int`	`getMaxParameterCount()` Obtain the number of parameters a query of this dialect is allowed by the database server.
`java.lang.String`	`getProcessedCharacterColumnName(java.lang.String name, boolean ignoreCase)` Adjust a character column name appropriate to this dialect, such that it can be inserted into an index.
`static java.util.List<java.lang.String>`	`getReservedKeywords()` Get a collection of reserved keywords specific to this dialect.
`java.lang.String`	`getSchemaPattern(Database database)` Provides schema matching pattern to load data correctly from JDBC.
`ScriptRunner`	`getScriptRunner()` Get a ScriptRunner instance for the dialect.
`java.lang.String`	`getSequenceCurrValString(java.lang.String sequenceName)` Generate the appropriate select statement to reset the value of a sequence.
`java.lang.String`	`getSequenceNextValString(java.lang.String sequenceName)` Generate the appropriate select statement to retrieve the next value of a sequence.
`java.lang.String`	`getSequencePrefetchString(java.lang.String sequenceName)` Generate the appropriate select statement to pre-fetch multiple, ascending values from a sequence.
`java.lang.String`	`getSequenceSetValString()` Generate the appropriate select statement to retrieve the next value of a sequence.
`java.lang.String`	`getSequenceSetValString(java.lang.String sequenceName)` Generate the appropriate select statement to retrieve the next value of a sequence.
`java.lang.String`	`getSequenceSetValString(java.lang.String sequenceName, long newVal)` Generate the appropriate select statement to retrieve the next value of a sequence.
`java.lang.String`	`getSequenceSQL(Database database)` Provides SQL to load sequences.
`java.lang.String`	`getSpecificTypeAsString(FqlType type)` Converts and return the specified `FqlType` to a string representation which can be used in a SQL query (`cast` or other construct).
`java.lang.String`	`getSqlIndexName(P2JIndex index)` Obtain the name of an index.
`java.lang.String`	`getSqlMappedType(java.lang.String fwdType, int scale, java.lang.Boolean caseSensitive)` Get the SQL mapping for a specific FWD data type.
`int`	`getSyntheticIndexSize(boolean unique)` Returns the size of the synthetic part of the index.
`private static long`	`getVacuumInterval()` Report the minimum number of milliseconds between explicit vacuums.
`boolean`	`hasFullSequenceSupport()` Returns `true` if this dialect fully support the sequences as 4GL language (most important: bounded values, cycle).
`java.lang.String`	`id()` Get dialect id.
`boolean`	`injectComputedColumns()` Report whether the computed columns should be injected on table creating.
`void`	`inlineLimit(boolean on)` Enable/disable limit clause inlining.
`boolean`	`isCaseInsensitiveColumn(java.lang.String name)` Report whether the given column name represents an alias or an expression which indicates the column is case insensitive.
`boolean`	`isComputedColumn(java.lang.String name)` Report whether the given column name represents an alias or an expression which indicates the column is computed.
`boolean`	`isConnectionError(java.lang.Exception exc)` Given an exception, this method will check if it indicates a database connectivity error.
`boolean`	`isMetadataSortAsc(java.lang.String value)` Check if the given value is an ascending clause for a column index.
`boolean`	`isMetadataSortDesc(java.lang.String value)` Check if the given value is a descending clause for a column index.
`boolean`	`isNativeUDFsSupported()` Check if native UDFs are supported for the dialect
`boolean`	`isQueryRangeParameterInlined()` Indicate whether a query parameter which is part of a range check should be inlined into the where clause, or whether it should be substituted into a prepared statement.
`boolean`	`isUdfOriginatedError(java.sql.SQLException e)` Check if the exception was caused by error in UDF.
`boolean`	`isUdfOriginatedWarning(java.sql.SQLException e)` Check if the exception was caused by a warning in UDF.
`boolean`	`isUniqueConstraintViolation(java.sql.SQLException sqle)` Checks if the SQLState of the SQLException matches the dialect specific UNIQUE_VIOLATION code for PostgreSQL (23505).
`private static java.lang.String`	`mapCollation(java.lang.String collation)` Maps the PostgreSQL specific collation names to 4GL collation names.
`private static java.lang.String`	`mapCP(java.lang.String collation)` Maps/extract from the PostgreSQL specific charset names to 4GL codepage names.
`boolean`	`needsComputedColumns()` Indicate whether this dialect requires computed columns to participate within index definitions, instead of embedded expressions.
`void`	`postTransaction(Persistence persistence, java.lang.Object context, boolean rollback)` A dialect-specific callback hook which is invoked by the persistence runtime framework after a transaction is complete.
`boolean`	`preferDisjunctiveForm()` Returns `true` if the dialect handles the optimization of an augmented construct which is resulted from comparing exactly two character fields.
`java.lang.String`	`prepareMetadataParameter(java.lang.String param)` Prepare the given metadata query parameter by making it lowercase.
`java.lang.String`	`processMetadataResult(java.lang.String value)` Process the given metadata query result, by making it lowercase.
`boolean`	`requiresExplicitCastInsideTernary()` Determines whether substitution parameters should be explicitly casted to their datatypes inside "then ? else ?" statement.
`ScriptSplitter`	`scriptSplitter()` Get a new instance of a splitter for DDL scripts.
`boolean`	`supportsBooleanDatatype()` Indicates whether this dialect supports boolean datatype.
`boolean`	`supportsFunctionOverloading()` Indicate whether this dialect natively supports the overloading of user defined functions by parameter number and data type.
`boolean`	`supportsVariableLimit()` Indicate whether a variable limit is supported by this dialect.
`ParmType`	`translateToParmType(java.lang.String type, java.lang.String comment)` Translation from database column type to `ParmType`.
`java.lang.String`	`udfSchema()` Get UDF schema name (if applicable).
`boolean`	`useCTE4Contains()` Check if Common Table Expressions should be used for converted CONTAINS operator
`boolean`	`useMixedNode4Contains()` Check if mixed mode re-write should be used for converted CONTAINS operator
`boolean`	`useUdf4Contains()` Check if UDF should be used for converted CONTAINS operator
`boolean`	`useWordTables()` Check if word tables should be used for converted CONTAINS operator
`java.util.Optional<Dialect.WeightAggregator>`	`weightAggregator()` Get the WeightAggregator instance for the dialect if defined

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

- Field Detail
  - LOG
```
private static final CentralLogger LOG
```
    Logger
  - useUdf4Contains
```
private static final boolean useUdf4Contains
```
    Allow runtime switch between word tables and UDF
  - useCte4Contains
```
private static final boolean useCte4Contains
```
    Allow runtime switch between using CTE for word tables and IN (SELECT ...)
  - useMixedMode4Contains
```
private static final boolean useMixedMode4Contains
```
    Allow runtime switch between 'pure' CTE mode and a 'mixed' one
  - UDF_ERROR_MESSAGE
```
private static final java.util.regex.Pattern UDF_ERROR_MESSAGE
```
    Regex Pattern for parsing message cased by error raised by UDF.
  - WEIGHT_AGGREGATOR
```
private static final Dialect.WeightAggregator WEIGHT_AGGREGATOR
```
    Weights' aggregator
  - PK
```
private static final java.lang.String PK
```
    Name of the primary key column.
  - TRIGGER_FUNC
```
private static final java.util.List<java.lang.String> TRIGGER_FUNC
```
    trigger function for words tables' support template
  - TRIGGER_FUNC_EXT
```
private static final java.util.List<java.lang.String> TRIGGER_FUNC_EXT
```
    trigger function for words tables' support template (extent field)
  - TRIGGER_FUNC_CEXT
```
private static final java.util.List<java.lang.String> TRIGGER_FUNC_CEXT
```
    trigger function for words tables' support template (custom extent field)
  - INS_TRIGGER_FUNC_CEXT
```
private static final java.util.List<java.lang.String> INS_TRIGGER_FUNC_CEXT
```
    ON INSERT trigger function for words tables' support template (custom extent field)
  - INS_TRIGGER_LINE
```
private static final java.lang.String INS_TRIGGER_LINE
```
    Repeatable line template for the ON INSERT trigger function for words tables' support template (custom extent field)
    
    See Also:
    
    Constant Field Values
  - AFTER_INSERT_TRIGGER
```
private static final java.util.List<java.lang.String> AFTER_INSERT_TRIGGER
```
    AFTER INSERT trigger for words tables' support template
  - AFTER_UPDATE_TRIGGER
```
private static final java.util.List<java.lang.String> AFTER_UPDATE_TRIGGER
```
    AFTER UPDATE trigger for words tables' support template
  - DROP_TRIGGER
```
private static final java.lang.String DROP_TRIGGER
```
    DROP TRIGGER statement
    
    See Also:
    
    Constant Field Values
  - DEFAULT_VACUUM_INTERVAL
```
private static final int DEFAULT_VACUUM_INTERVAL
```
    Default minimum interval in seconds between temp table vacuums
    
    See Also:
    
    Constant Field Values
  - debug
```
private static final boolean debug
```
    Debug level logging enabled?
  - inlineLimit
```
private static final java.lang.ThreadLocal<java.lang.Boolean> inlineLimit
```
    Flag indicating whether to inline a record limit in an SQL SELECT
  - lowDate
```
private static final java.sql.Date lowDate
```
    Lowest date supported by PostgreSQL (01/01/4713 BC)
  - highDate
```
private static final java.sql.Date highDate
```
    Highest date supported by PostgreSQL (12/31/32767 AD)
  - vacuumInterval
```
private static long vacuumInterval
```
    Actual minimum interval in milliseconds between temp table vacuums
  - fwd2sql
```
private static java.util.Map<java.lang.String,java.lang.String> fwd2sql
```
    Mapping between the FWD possible field/column types and their SQL counterparts.
- Constructor Detail
  - P2JPostgreSQLDialect
```
public P2JPostgreSQLDialect()
```
    Default constructor. This constructor is for Hibernate's use. Use code should not construct instances of this class.
    We provide this constructor to override the superclass' mapping of Types.VARCHAR, in order to force this type to map to PostgreSQL's text data type.
- Method Detail
  - getReservedKeywords
```
public static java.util.List<java.lang.String> getReservedKeywords()
```
    Get a collection of reserved keywords specific to this dialect. The NameConverter uses thes list to create an exclusion list of names so there will not be schema collisions with identifiers (tables, fields) from the generated schema.
    
    Returns:
    
    A list with PostgreSQL 9.3 reserved keywords in lowercase.
    
    See Also:
    
    http://www.postgresql.org/docs/9.3/static/sql-keywords-appendix.html
  - getVacuumInterval
```
private static long getVacuumInterval()
```
    Report the minimum number of milliseconds between explicit vacuums. This number is retrieved from the directory, or if not configured there, is defaulted to a standard interval.
    
    Returns:
    
    Minimum number of milliseconds between vacuums.
  - getDriverClassName
```
public java.lang.String getDriverClassName()
```
    Get the name of the JDBC driver class associated with this dialect.
    
    Specified by:
    
    getDriverClassName in class Dialect
    
    Returns:
    
    Fully qualified driver class name.
  - getJdbcDatabaseType
```
public java.lang.String getJdbcDatabaseType()
```
    Get the name of the JDBC database type (as in JBC URL).
    
    Specified by:
    
    getJdbcDatabaseType in class Dialect
    
    Returns:
    
    The name of the JDBC database type.
  - needsComputedColumns
```
public boolean needsComputedColumns()
```
    Indicate whether this dialect requires computed columns to participate within index definitions, instead of embedded expressions.
    
    Specified by:
    
    needsComputedColumns in class Dialect
    
    Returns:
    
    false to indicate the backing database can embed an expression within an index definition.
  - supportsFunctionOverloading
```
public boolean supportsFunctionOverloading()
```
    Indicate whether this dialect natively supports the overloading of user defined functions by parameter number and data type.
    
    Specified by:
    
    supportsFunctionOverloading in class Dialect
    
    Returns:
    
    true.
  - supportsBooleanDatatype
```
public boolean supportsBooleanDatatype()
```
    Indicates whether this dialect supports boolean datatype. Support includes:
    - usage of true and false literals;
    - operations with boolean values;
    - allowing functions to have booleans as parameters and return datatype.
    Specified by:
    
    supportsBooleanDatatype in class Dialect
    
    Returns:
    
    Always true, all the above mentioned items are supported.
  - createContext
```
public java.lang.Object createContext(Persistence persistence)
```
    Create a data object, the purpose of which is specific to a particular dialect implementation, to be stored as a context-local object. This allows a dialect to establish context-local data which is stored by the persistence runtime framework, without the overhead of a separate, context-local variable. This object will be handed back to the dialect in callback methods when the services of certain hooks are required.
    Since the context-local data is specific to a particular dialect implementation, it is optional. Dialect implementations which do not have a need for this data should simply return null.
    
    Overrides:
    
    createContext in class Dialect
    
    Parameters:
    
    persistence - Provider of persistence services.
    
    Returns:
    
    Dialect-specific, context-local data, or null.
  - postTransaction
```
public void postTransaction(Persistence persistence,
                            java.lang.Object context,
                            boolean rollback)
                     throws PersistenceException
```
    A dialect-specific callback hook which is invoked by the persistence runtime framework after a transaction is complete. The Hibernate session will have been closed by the time this method is invoked.
    
    Overrides:
    
    postTransaction in class Dialect
    
    Parameters:
    
    persistence - Provider of persistence services.
    
    context - Optional, context-local data created previously by createContext(com.goldencode.p2j.persist.Persistence).
    
    rollback - true if transaction ended with a rollback; false if transaction ended with a commit.
    
    Throws:
    
    PersistenceException - if any persistence-related error occurs.
  - getLowDate
```
public java.sql.Date getLowDate()
```
    Retrieve the earliest possible date value which is valid for the backing database.
    
    Overrides:
    
    getLowDate in class Dialect
    
    Returns:
    
    Earliest date supported by the backing database.
  - getHighDate
```
public java.sql.Date getHighDate()
```
    Retrieve the latest possible date value which is valid for the backing database.
    
    Overrides:
    
    getHighDate in class Dialect
    
    Returns:
    
    Latest date supported by the backing database.
  - formatDate
```
public java.lang.String formatDate(date d)
```
    Format a date object as a string which is appropriate for use in an SQL statement.
    
    Specified by:
    
    formatDate in class Dialect
    
    Parameters:
    
    d - Date to be formatted as a string.
    
    Returns:
    
    Formatted representation of the given date.
  - extractColumnName
```
public java.lang.String extractColumnName(java.lang.String expr)
```
    Given a column expression as queried from database metadata, extract the root name of a column. For example, a column name as found within an index in metadata might be represented as:
```
    upper(rtrim("key"::text))
 
```
    We are interested only in the key root name, so we strip away the upper() and rtrim() functions the double quotes, and the ::text suffix.
    Specified by:
    
    extractColumnName in class Dialect
    
    Parameters:
    
    expr - Expression containing column name as natively represented by the database dialect.
    
    Returns:
    
    Root column name.
  - getProcessedCharacterColumnName
```
public java.lang.String getProcessedCharacterColumnName(java.lang.String name,
                                                        boolean ignoreCase)
```
    Adjust a character column name appropriate to this dialect, such that it can be inserted into an index. This involves wrapping the name within an rtrim function, and if ignoreCase is true, an upper function.
    
    Specified by:
    
    getProcessedCharacterColumnName in class Dialect
    
    Parameters:
    
    name - Base column name.
    
    ignoreCase - true to cause case to be ignored, else false.
    
    Returns:
    
    Processed column name.
  - isCaseInsensitiveColumn
```
public boolean isCaseInsensitiveColumn(java.lang.String name)
```
    Report whether the given column name represents an alias or an expression which indicates the column is case insensitive. Assume the column represented by name is already determined to be the appropriate data type for textual data.
    
    Specified by:
    
    isCaseInsensitiveColumn in class Dialect
    
    Parameters:
    
    name - Column name, alias, or expression.
    
    Returns:
    
    true if name represents case-insensitive data.
  - isComputedColumn
```
public boolean isComputedColumn(java.lang.String name)
```
    Report whether the given column name represents an alias or an expression which indicates the column is computed. Assume the column represented by name is already determined to be the appropriate data type for textual data.
    
    Overrides:
    
    isComputedColumn in class Dialect
    
    Parameters:
    
    name - Column name, alias, or expression.
    
    Returns:
    
    true if name represents a computed column.
  - getCreateSequenceString
```
public java.lang.String getCreateSequenceString(java.lang.String name)
```
    Generate a DDL string which will create a global sequence.
    
    Specified by:
    
    getCreateSequenceString in class Dialect
    
    Parameters:
    
    name - Sequence name.
    
    Returns:
    
    Dialect-specific string to create the sequence, or null if not supported.
  - getCreateSequenceString
```
public java.lang.String getCreateSequenceString(java.lang.String name,
                                                long start)
```
    Generate a DDL string which will create a global sequence with the given starting value.
    
    Specified by:
    
    getCreateSequenceString in class Dialect
    
    Parameters:
    
    name - Sequence name.
    
    start - Sequence starting value.
    
    Returns:
    
    Dialect-specific string to create the sequence, or null if not supported.
  - getCreateSequenceString
```
public java.lang.String getCreateSequenceString(java.lang.String name,
                                                java.lang.Long init,
                                                java.lang.Long increment,
                                                java.lang.Long minVal,
                                                java.lang.Long maxVal,
                                                java.lang.Boolean cycle)
```
    Generate a DDL string which will create a sequence with given properties.
    
    Specified by:
    
    getCreateSequenceString in class Dialect
    
    Parameters:
    
    name - Sequence name. Mandatory not null.
    
    init - Sequence starting value. Mandatory(not null).
    
    increment - Sequence incrementing value. Mandatory(not null).
    
    minVal - Sequence minimum value. Optional (may be null).
    
    maxVal - Sequence maximum value. Optional (may be null).
    
    cycle - Sequence cycling property. Optional, if missing assumed not cycling.
    
    Returns:
    
    Dialect-specific string to create the sequence, or null if not supported.
  - getDropSequenceString
```
public java.lang.String getDropSequenceString(java.lang.String name)
```
    Generate a DDL string which will drop a sequence.
    
    Specified by:
    
    getDropSequenceString in class Dialect
    
    Parameters:
    
    name - The name of the sequence to be dropped.
    
    Returns:
    
    Dialect-specific string to drop the sequence, or null if not supported.
  - getSequenceSetValString
```
public java.lang.String getSequenceSetValString(java.lang.String sequenceName,
                                                long newVal)
```
    Generate the appropriate select statement to retrieve the next value of a sequence.
    
    Specified by:
    
    getSequenceSetValString in class Dialect
    
    Parameters:
    
    sequenceName - The name of the sequence.
    
    newVal - The new value to be set.
    
    Returns:
    
    Dialect-specific string to query the sequence, or null if not supported.
  - getSequenceSetValString
```
public java.lang.String getSequenceSetValString(java.lang.String sequenceName)
```
    Generate the appropriate select statement to retrieve the next value of a sequence.
    
    Specified by:
    
    getSequenceSetValString in class Dialect
    
    Parameters:
    
    sequenceName - The name of the sequence.
    
    Returns:
    
    Dialect-specific string to query the sequence, or null if not supported.
  - getSequenceSetValString
```
public java.lang.String getSequenceSetValString()
```
    Generate the appropriate select statement to retrieve the next value of a sequence.
    
    Specified by:
    
    getSequenceSetValString in class Dialect
    
    Returns:
    
    Dialect-specific string to query the sequence, or null if not supported.
  - getSequenceNextValString
```
public java.lang.String getSequenceNextValString(java.lang.String sequenceName)
```
    Generate the appropriate select statement to retrieve the next value of a sequence.
    
    Specified by:
    
    getSequenceNextValString in class Dialect
    
    Parameters:
    
    sequenceName - The name of the sequence to be queried.
    
    Returns:
    
    Dialect-specific string to query the sequence, or null if not supported.
  - getSequenceCurrValString
```
public java.lang.String getSequenceCurrValString(java.lang.String sequenceName)
```
    Generate the appropriate select statement to reset the value of a sequence.
    
    Specified by:
    
    getSequenceCurrValString in class Dialect
    
    Parameters:
    
    sequenceName - The name of the sequence to be queried.
    
    Returns:
    
    Dialect-specific string to query the sequence, or null if not supported.
  - hasFullSequenceSupport
```
public boolean hasFullSequenceSupport()
```
    Returns true if this dialect fully support the sequences as 4GL language (most important: bounded values, cycle). If not fully supported, additional code is needed in P2J sequence class implementation to fix this.
    
    Specified by:
    
    hasFullSequenceSupport in class Dialect
    
    Returns:
    
    true because PostgreSQL dialect fully support 4GL sequences
  - getSequencePrefetchString
```
public java.lang.String getSequencePrefetchString(java.lang.String sequenceName)
```
    Generate the appropriate select statement to pre-fetch multiple, ascending values from a sequence. The values need not be contiguous.
    
    Specified by:
    
    getSequencePrefetchString in class Dialect
    
    Parameters:
    
    sequenceName - The name of the sequence from which the values are to be retrieved.
    
    Returns:
    
    Dialect-specific SQL expression, or null if this feature is not supported by the dialect.
  - isConnectionError
```
public boolean isConnectionError(java.lang.Exception exc)
```
    Given an exception, this method will check if it indicates a database connectivity error.
    For the PostgreSQL dialect, if the state indicates a 08xxx error code or 57P01 or 57P02 codes, the method will return true.
    A complete list of defined error codes can be found here: http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html
    
    Specified by:
    
    isConnectionError in class Dialect
    
    Parameters:
    
    exc - The exception to be checked.
    
    Returns:
    
    true if the exception indicates a database connectivity error.
  - isQueryRangeParameterInlined
```
public boolean isQueryRangeParameterInlined()
```
    Indicate whether a query parameter which is part of a range check should be inlined into the where clause, or whether it should be substituted into a prepared statement. This will result in an "inlined" substitution parameter within a where clause. For example, given a where clause of:
```
    where value ≥ ? and id = ?
 
```
    along with respective substitution parameters of 45 and 100, the inlined version would read:
```
    where value ≥ 45 and id = ?
 
```
    Only the id substitution parameter of 100 would be substituted into the prepared statement.
    Inlining in such a way can give some database dialects the opportunity to choose a better query plan, than if the parameter being tested with a range check were to be substituted at statement execution time.
    Note: this serves as a hint which may be overridden by runtime logic or other configuration settings.
    Specified by:
    
    isQueryRangeParameterInlined in class Dialect
    
    Returns:
    
    true to inline range check parameters; false to use normal parameter substitution.
  - inlineLimit
```
public void inlineLimit(boolean on)
```
    Enable/disable limit clause inlining. Inlining the limit clause will cause the limit/max value to be hard-coded into the SQL statement, rather than being bound as a substitution parameter.
    Dialects are free to treat this method as a hint.
    
    Specified by:
    
    inlineLimit in class Dialect
    
    Parameters:
    
    on - true to enable inlining; false to disable it.
  - requiresExplicitCastInsideTernary
```
public boolean requiresExplicitCastInsideTernary()
```
    Determines whether substitution parameters should be explicitly casted to their datatypes inside "then ? else ?" statement.
    
    Specified by:
    
    requiresExplicitCastInsideTernary in class Dialect
    
    Returns:
    
    false.
  - getLimitString
```
public java.lang.String getLimitString(java.lang.String sql,
                                       int offset,
                                       int limit)
```
    Override the parent's implementation to inline small (2 or less) limit values when there is no accompanying offset. In other cases, we fall back to the original implementation.
    WARNING: the implementation of this override has an ugly dependency on the order of the logic in Hibernate's Loader class. Specifically, we rely on the fact that this method is invoked when a query is being prepared, which must happen before parameters are bound, at which point supportsVariableLimit() is invoked. This method sets state in a context local variable which is later read when the latter method is invoked.
    
    Overrides:
    
    getLimitString in class Dialect
    
    Parameters:
    
    sql - Base select statement SQL without the limit/offset clause.
    
    offset - Starting offset.
    
    limit - Number of records to return.
    
    Returns:
    
    SQL with limit/offset clause appended.
    
    See Also:
    
    supportsVariableLimit()
  - supportsVariableLimit
```
public boolean supportsVariableLimit()
```
    Indicate whether a variable limit is supported by this dialect. The answer is dependent upon context local state set within getLimitString(String, int, int). See the applicable warning in that method's description. This method is consulted during parameter binding in Hibernate's Loader class.
    
    Overrides:
    
    supportsVariableLimit in class Dialect
    
    Returns:
    
    true if a bound parameter should be used in a SELECT statement's limit clause; false if the limit was inlined by getLimitString(String, int, int).
  - getDropIndexString
```
public java.lang.String getDropIndexString(P2JIndex index)
```
    Build the DDL to drop an index based upon the specified definition. The SQL is generated by using the database-specific dialect.
    
    Specified by:
    
    getDropIndexString in class Dialect
    
    Parameters:
    
    index - Definition of the index to be dropped.
    
    Returns:
    
    The DDL to drop the given index.
  - getComputedColumnFormula
```
public java.lang.String getComputedColumnFormula(java.lang.String colName,
                                                 boolean ignoreCase)
```
    Returns the formula for character computed columns. This will be called in two cases: when generating the ddl for permanent databases schema (this will be written to a .sql file) and when creating temp-tables (the code will be sent directly to SQL).
    
    Overrides:
    
    getComputedColumnFormula in class Dialect
    
    Parameters:
    
    colName - The base column name.
    
    ignoreCase - true if this is a char field which has the "ignore case" flag set.
    
    Returns:
    
    Always null because this dialect does not use computed columns.
  - prepareMetadataParameter
```
public java.lang.String prepareMetadataParameter(java.lang.String param)
```
    Prepare the given metadata query parameter by making it lowercase.
    
    Specified by:
    
    prepareMetadataParameter in class Dialect
    
    Parameters:
    
    param - The metadata query parameter.
    
    Returns:
    
    the lowercased parameter.
  - processMetadataResult
```
public java.lang.String processMetadataResult(java.lang.String value)
```
    Process the given metadata query result, by making it lowercase.
    
    Specified by:
    
    processMetadataResult in class Dialect
    
    Parameters:
    
    value - The metadata query result.
    
    Returns:
    
    the lowercased result.
  - isMetadataSortDesc
```
public boolean isMetadataSortDesc(java.lang.String value)
```
    Check if the given value is a descending clause for a column index.
    
    Specified by:
    
    isMetadataSortDesc in class Dialect
    
    Parameters:
    
    value - The value to be checked.
    
    Returns:
    
    true if the value is the "D" or "d" string.
  - isMetadataSortAsc
```
public boolean isMetadataSortAsc(java.lang.String value)
```
    Check if the given value is an ascending clause for a column index.
    
    Specified by:
    
    isMetadataSortAsc in class Dialect
    
    Parameters:
    
    value - The value to be checked.
    
    Returns:
    
    true if the value is the "A" or "a" string.
  - getDatabasePrepareStatements
```
public java.util.List<java.lang.String> getDatabasePrepareStatements(Database database)
```
    Get a list of database prepare DDL statements.
    
    Overrides:
    
    getDatabasePrepareStatements in class Dialect
    
    Parameters:
    
    database - The database which needs to be prepared.
    
    Returns:
    
    an empty list.
  - explicitSetCollation
```
public boolean explicitSetCollation()
```
    Check if the dialect needs to set an explicit collation during schema DDL generation.
    
    Specified by:
    
    explicitSetCollation in class Dialect
    
    Returns:
    
    always false.
  - getDelimiter
```
public java.lang.String getDelimiter()
```
    Get the statement delimiter for this dialect.
    
    Specified by:
    
    getDelimiter in class Dialect
    
    Returns:
    
    the statement delimiter.
  - buildRemoteURL
```
public java.lang.String buildRemoteURL(java.lang.String url,
                                       Database database)
                                throws PersistenceException
```
    Build the URL to be used for a remote connection, based on the given URL and database.
    
    Specified by:
    
    buildRemoteURL in class Dialect
    
    Parameters:
    
    url - The URL as received from the remote server.
    
    database - The database to which this URL belongs.
    
    Returns:
    
    The built URL as to be used for a remote connection.
    
    Throws:
    
    PersistenceException - if the specified connection URL is invalid.
  - createSequenceHandler
```
public SequenceHandler createSequenceHandler(java.lang.String ldbName)
```
    Creates and returns a SequenceHandler for a PostgresSQL database.
    
    Specified by:
    
    createSequenceHandler in class Dialect
    
    Parameters:
    
    ldbName - The logical name of the database to create the SequenceHandler for.
    
    Returns:
    
    A PostgreSQLSequenceHandler instance.
  - injectComputedColumns
```
public boolean injectComputedColumns()
```
    Report whether the computed columns should be injected on table creating.
    
    Specified by:
    
    injectComputedColumns in class Dialect
    
    Returns:
    
    false because PostgreSQL does not support computed columns.
  - isUniqueConstraintViolation
```
public boolean isUniqueConstraintViolation(java.sql.SQLException sqle)
```
    Checks if the SQLState of the SQLException matches the dialect specific UNIQUE_VIOLATION code for PostgreSQL (23505).
    
    Specified by:
    
    isUniqueConstraintViolation in class Dialect
    
    Parameters:
    
    sqle - The SQLException that is causing the unique constraint violation.
    
    Returns:
    
    true if the SQLState matches the dialect specific code for UNIQUE_VIOLATION, false otherwise.
  - getComputedColumnString
```
public java.lang.String getComputedColumnString(java.lang.String name,
                                                java.lang.String type,
                                                int scale,
                                                boolean cs)
```
    Constructs and returns the declaration of a computed column based on its name, type, scale, and case-sensitiveness.
    
    Overrides:
    
    getComputedColumnString in class Dialect
    
    Parameters:
    
    name - The original column name.
    
    type - The original column type.
    
    scale - The optional scale, if needed.
    
    cs - The case-sensitiveness.
    
    Returns:
    
    always null. This dialect does not use computed columns.
  - getSequenceSQL
```
public java.lang.String getSequenceSQL(Database database)
```
    Provides SQL to load sequences.
    
    Overrides:
    
    getSequenceSQL in class Dialect
    
    Parameters:
    
    database - database object
    
    Returns:
    
    sequence SQL
  - getIndexLengthLimit
```
public int getIndexLengthLimit()
```
    Some dialects do have constraints about the maximum size of fields that compose an index. This method reports the dialect-specific index length limit, if any.
    
    Overrides:
    
    getIndexLengthLimit in class Dialect
    
    Returns:
    
    always 0 as this dialect do not have any known constraints about the maximum size of the fields of an index.
  - getSyntheticIndexSize
```
public int getSyntheticIndexSize(boolean unique)
```
    Returns the size of the synthetic part of the index. At this moment only the id of the record may be additionally added to an index to add custom properties (eg uniqueness) but other fields could be added. This part of the index is not visible using index reflection routines from IndexHelper. The synthetic components may differ between unique and non-unique indexes.
    See Dialect.getCreateIndexString(P2JIndex, boolean, boolean)
    
    Specified by:
    
    getSyntheticIndexSize in class Dialect
    
    Parameters:
    
    unique - true if the index is unique
    
    Returns:
    
    0 if index is unique, 8 = size of an pkid (int8)
  - addRtrimmedExpression
```
public void addRtrimmedExpression(java.lang.String expr,
                                  java.lang.StringBuilder sb)
```
    Composes a rtrim equivalent call for a specified expr. This is dialect specific. The returned value looks like:
```
    rtrim(expr)
 
```
    The rtrim'd expression is appended to the string builder.
    Specified by:
    
    addRtrimmedExpression in class Dialect
    
    Parameters:
    
    expr - The expression to be rtrim -med. It's up to the caller if it is a qualified field or not or any other kind of character-type expression.
    
    sb - The StringBuilder to append the trimmed filed to.
  - getMaxParameterCount
```
public int getMaxParameterCount()
```
    Obtain the number of parameters a query of this dialect is allowed by the database server.
    
    Overrides:
    
    getMaxParameterCount in class Dialect
    
    Returns:
    
    Always 0 because PostgreSQL has no such limitation.
  - getCreateTemporaryTableString
```
public java.lang.String getCreateTemporaryTableString(boolean ifNotExist)
```
    Return the beginning of the DDL statement that creates a temporary table.
    
    Specified by:
    
    getCreateTemporaryTableString in class Dialect
    
    Parameters:
    
    ifNotExist - If true an dialect-specific, optional if not exist clause is added.
    
    Returns:
    
    A string representing the beginning of the DDL statement that creates a temporary table.
  - getCreateTemporaryTablePostfix
```
public java.lang.String getCreateTemporaryTablePostfix(boolean noUndo)
```
    Return the ending of the DDL statement that creates a temporary table.
    
    Specified by:
    
    getCreateTemporaryTablePostfix in class Dialect
    
    Parameters:
    
    noUndo - This parameter is not used at the moment. The intention was to generate a keyword for no-undo tables. Only P2JH2Dialect benefits from this parameter.
    
    Returns:
    
    A string representing the ending of the DDL statement that creates a temporary table.
  - getDropIndexString
```
public java.lang.String getDropIndexString(boolean ifExists,
                                           java.lang.String idxName,
                                           java.lang.String tableName)
```
    Obtain a DDL statement which drops a SQL index.
    
    Specified by:
    
    getDropIndexString in class Dialect
    
    Parameters:
    
    ifExists - Flag that requires that the DDL include an optional IF EXIST clause.
    
    idxName - The name of the index to be dropped by this DDL.
    
    tableName - The name of the table to which the index belongs to. (Optional, is needed by the dialect).
    
    Returns:
    
    a DDL statement which drops a SQL index.
  - getDropTableString
```
public java.lang.String getDropTableString(boolean ifExists,
                                           java.lang.String tableName)
```
    Obtain a DDL statement which drops a SQL table.
    
    Specified by:
    
    getDropTableString in class Dialect
    
    Parameters:
    
    ifExists - Flag that requires that the DDL include an optional IF EXIST clause.
    
    tableName - The name of the table to be dropped by this DDL.
    
    Returns:
    
    a DDL statement which drops a SQL index.
  - getSpecificTypeAsString
```
public java.lang.String getSpecificTypeAsString(FqlType type)
```
    Converts and return the specified FqlType to a string representation which can be used in a SQL query (cast or other construct).
    
    Overrides:
    
    getSpecificTypeAsString in class Dialect
    
    Parameters:
    
    type - The type to be converted to string.
    
    Returns:
    
    A dialect specific string representation of the respective fql data type.
  - translateToParmType
```
public ParmType translateToParmType(java.lang.String type,
                                    java.lang.String comment)
```
    Translation from database column type to ParmType.
    
    Overrides:
    
    translateToParmType in class Dialect
    
    Parameters:
    
    type - Column type.
    
    comment - comment with optional specification of type
    
    Returns:
    
    ParmType
    
    Throws:
    
    java.lang.IllegalArgumentException - for unsupported types.
  - getSqlMappedType
```
public java.lang.String getSqlMappedType(java.lang.String fwdType,
                                         int scale,
                                         java.lang.Boolean caseSensitive)
```
    Get the SQL mapping for a specific FWD data type.
    
    Overrides:
    
    getSqlMappedType in class Dialect
    
    Parameters:
    
    fwdType - The FWD type.
    
    scale - Optional scale parameter (for decimal data type).
    
    Returns:
    
    The string representation of the SQL datatype mapped by fwdType.
  - getAnalyzeString
```
public java.lang.String getAnalyzeString(java.lang.String table)
```
    Construct and return a string which represents the analyze or similar statements for this dialect. If the table is not null the statement will analyze only the respective table. Otherwise, all the tables are analyzed.
    
    Specified by:
    
    getAnalyzeString in class Dialect
    
    Parameters:
    
    table - The name of the table to be analyzed. If null, all tables from the database will be analyzed, if possible.
    
    Returns:
    
    The analyze statement as requested. If the dialect does not support the analyze statement in the form requested null is returned.
  - scriptSplitter
```
public ScriptSplitter scriptSplitter()
```
    Get a new instance of a splitter for DDL scripts.
    
    Specified by:
    
    scriptSplitter in class Dialect
    
    Returns:
    
    the splitter for DDL scripts.
  - getScriptRunner
```
public ScriptRunner getScriptRunner()
```
    Get a ScriptRunner instance for the dialect.
    
    Specified by:
    
    getScriptRunner in class Dialect
    
    Returns:
    
    a ScriptRunner instance for the dialect.
  - blobCreator
```
public java.sql.Blob blobCreator(java.sql.Connection conn,
                                 byte[] bytes)
```
    Create a Blob instance from the specified bytes.
    
    Specified by:
    
    blobCreator in class Dialect
    
    Parameters:
    
    conn - The JDBC connection.
    
    bytes - The blob data.
    
    Returns:
    
    The blob instance.
  - clobCreator
```
public java.sql.Clob clobCreator(java.sql.Connection conn,
                                 java.lang.String value)
```
    Create a Clob instance from the specified value.
    
    Specified by:
    
    clobCreator in class Dialect
    
    Parameters:
    
    conn - The JDBC connection.
    
    value - The clob data.
    
    Returns:
    
    The clob instance.
  - useUdf4Contains
```
public boolean useUdf4Contains()
```
    Check if UDF should be used for converted CONTAINS operator
    
    Specified by:
    
    useUdf4Contains in class Dialect
    
    Returns:
    
    true if UDF should be used for converted CONTAINS operator
  - useWordTables
```
public boolean useWordTables()
```
    Check if word tables should be used for converted CONTAINS operator
    
    Specified by:
    
    useWordTables in class Dialect
    
    Returns:
    
    true if tables should be used for converted CONTAINS operator
  - isNativeUDFsSupported
```
public boolean isNativeUDFsSupported()
```
    Check if native UDFs are supported for the dialect
    
    Specified by:
    
    isNativeUDFsSupported in class Dialect
    
    Returns:
    
    true if native UDFs are supported for the dialect
  - udfSchema
```
public java.lang.String udfSchema()
```
    Get UDF schema name (if applicable).
    
    Overrides:
    
    udfSchema in class Dialect
    
    Returns:
    
    UDF schema name (if applicable).
  - isUdfOriginatedError
```
public boolean isUdfOriginatedError(java.sql.SQLException e)
```
    Check if the exception was caused by error in UDF.
    
    Overrides:
    
    isUdfOriginatedError in class Dialect
    
    Parameters:
    
    e - the exception in question
    
    Returns:
    
    true if the exception was caused by error in UDF.
  - isUdfOriginatedWarning
```
public boolean isUdfOriginatedWarning(java.sql.SQLException e)
```
    Check if the exception was caused by a warning in UDF.
    
    Overrides:
    
    isUdfOriginatedWarning in class Dialect
    
    Parameters:
    
    e - the exception in question
    
    Returns:
    
    true if the exception was caused by error in UDF.
  - errorEntry
```
public ErrorManager.ErrorEntry errorEntry(java.lang.String message)
```
    Create the error descriptor from the SQLException message
    
    Overrides:
    
    errorEntry in class Dialect
    
    Parameters:
    
    message - SQLException message
    
    Returns:
    
    error descriptor.
  - useCTE4Contains
```
public boolean useCTE4Contains()
```
    Check if Common Table Expressions should be used for converted CONTAINS operator
    
    Overrides:
    
    useCTE4Contains in class Dialect
    
    Returns:
    
    true if Common Table Expressions should be used for converted CONTAINS operator
  - useMixedNode4Contains
```
public boolean useMixedNode4Contains()
```
    Check if mixed mode re-write should be used for converted CONTAINS operator
    
    Overrides:
    
    useMixedNode4Contains in class Dialect
    
    Returns:
    
    true if mixed mode re-write should be used
  - weightAggregator
```
public java.util.Optional<Dialect.WeightAggregator> weightAggregator()
```
    Get the WeightAggregator instance for the dialect if defined
    
    Overrides:
    
    weightAggregator in class Dialect
    
    Returns:
    
    the WeightAggregator instance for the dialect if defined
  - id
```
public java.lang.String id()
```
    Get dialect id.
    
    Specified by:
    
    id in class Dialect
    
    Returns:
    
    Dialect id
  - connectionCustomizer
```
public java.lang.Class<? extends com.mchange.v2.c3p0.AbstractConnectionCustomizer> connectionCustomizer(DatabaseConfig cfg)
```
    Get c3p0 ConnectionCustomizer class for the dialect.
    
    Overrides:
    
    connectionCustomizer in class Dialect
    
    Type Parameters:
    
    T - Customizer class
    
    Parameters:
    
    cfg - Database configuration.
    
    Returns:
    
    c3p0 ConnectionCustomizer class for the dialect.
  - generateWordTablesDDLImpl
```
public void generateWordTablesDDLImpl(java.lang.String dbName,
                                      java.io.PrintStream out,
                                      java.lang.String eoln,
                                      java.util.Collection<WordTable> wordTables)
```
    Worker method for generateTriggerDDLs(). It generates the DDLs needed to create all triggers in a database with a specific schema and using a certain dialect.
    
    Specified by:
    
    generateWordTablesDDLImpl in class Dialect
    
    Parameters:
    
    dbName - The target schema.
    
    out - The PrintStream used for output.
    
    eoln - OS-specific end of line terminator.
    
    wordTables - word tables by name
  - getCatalogPattern
```
public java.lang.String getCatalogPattern(Database database)
```
    Provides catalog matching pattern to load data correctly from JDBC.
    
    Overrides:
    
    getCatalogPattern in class Dialect
    
    Parameters:
    
    database - database object
    
    Returns:
    
    catalog pattern
  - getSchemaPattern
```
public java.lang.String getSchemaPattern(Database database)
```
    Provides schema matching pattern to load data correctly from JDBC.
    
    Overrides:
    
    getSchemaPattern in class Dialect
    
    Parameters:
    
    database - database object
    
    Returns:
    
    schema pattern
  - getSqlIndexName
```
public java.lang.String getSqlIndexName(P2JIndex index)
```
    Obtain the name of an index. This dialect overrides this method in order to make sure the name is unique among tables because in PSQL the index names must be unique.
    
    Overrides:
    
    getSqlIndexName in class Dialect
    
    Parameters:
    
    index - The index structure.
    
    Returns:
    
    the unique SQL name of the index.
  - getMaxEntriesInSelect
```
public int getMaxEntriesInSelect()
```
    Description copied from class: Dialect
    
    Returns the max numbers of fields selected that the dialect can allow without throwing an error.
    
    Overrides:
    
    getMaxEntriesInSelect in class Dialect
    
    Returns:
    
    Maximum of selected fields allowed
  - getCodepage
```
public java.lang.String getCodepage(java.sql.Connection conn)
```
    Use the provided database connection to extract the codepage/CharSet used by the database and report it back to the caller.
    
    Overrides:
    
    getCodepage in class Dialect
    
    Parameters:
    
    conn - The JDBC database connection to be used.
    
    Returns:
    
    The name of the codepage/CharSet used by the database to store character data.
  - getCollation
```
public java.lang.String getCollation(java.sql.Connection conn)
```
    Use the provided database connection to extract the collation used by the database and report it back to the caller.
    
    Overrides:
    
    getCollation in class Dialect
    
    Parameters:
    
    conn - The JDBC database connection to be used.
    
    Returns:
    
    The name of the collation used by the database to store character data.
  - preferDisjunctiveForm
```
public boolean preferDisjunctiveForm()
```
    Returns true if the dialect handles the optimization of an augmented construct which is resulted from comparing exactly two character fields.
    
    Overrides:
    
    preferDisjunctiveForm in class Dialect
    
    Returns:
    
    as described above.
  - mapCP
```
private static java.lang.String mapCP(java.lang.String collation)
```
    Maps/extract from the PostgreSQL specific charset names to 4GL codepage names.
    
    Parameters:
    
    collation - A PostgreSQL specific collation name. (Ex: "en_US@p2j_basic", "en_US.utf8", "C", "en_US@iso88591_fwd_basic" (default))
    
    Returns:
    
    The 4GL codepage name of h2Charset.
  - mapCollation
```
private static java.lang.String mapCollation(java.lang.String collation)
```
    Maps the PostgreSQL specific collation names to 4GL collation names.
    
    Parameters:
    
    collation - A PostgreSQL specific collation name. (Ex: "en_US@p2j_basic", "en_US.utf8", "C", "en_US@iso88591_fwd_basic" (default))
    
    Returns:
    
    The 4GL codepage name of h2Charset.

Class P2JPostgreSQLDialect

Nested Class Summary

Nested classes/interfaces inherited from class com.goldencode.p2j.persist.dialect.Dialect

Field Summary

Fields inherited from class com.goldencode.p2j.persist.dialect.Dialect

Constructor Summary

Method Summary

Methods inherited from class com.goldencode.p2j.persist.dialect.Dialect

Methods inherited from class java.lang.Object

Field Detail

LOG

useUdf4Contains

useCte4Contains

useMixedMode4Contains

UDF_ERROR_MESSAGE

WEIGHT_AGGREGATOR

PK

TRIGGER_FUNC

TRIGGER_FUNC_EXT

TRIGGER_FUNC_CEXT

INS_TRIGGER_FUNC_CEXT

INS_TRIGGER_LINE

AFTER_INSERT_TRIGGER

AFTER_UPDATE_TRIGGER

DROP_TRIGGER

DEFAULT_VACUUM_INTERVAL

debug

inlineLimit

lowDate

highDate

vacuumInterval

fwd2sql

Constructor Detail

P2JPostgreSQLDialect

Method Detail

getReservedKeywords

getVacuumInterval

getDriverClassName

getJdbcDatabaseType

needsComputedColumns

supportsFunctionOverloading

supportsBooleanDatatype

createContext

postTransaction

getLowDate

getHighDate

formatDate

extractColumnName

getProcessedCharacterColumnName

isCaseInsensitiveColumn

isComputedColumn

getCreateSequenceString

getCreateSequenceString

getCreateSequenceString

getDropSequenceString

getSequenceSetValString

getSequenceSetValString

getSequenceSetValString

getSequenceNextValString

getSequenceCurrValString

hasFullSequenceSupport

getSequencePrefetchString

isConnectionError

isQueryRangeParameterInlined

inlineLimit

requiresExplicitCastInsideTernary

getLimitString

supportsVariableLimit

getDropIndexString

getComputedColumnFormula

prepareMetadataParameter

processMetadataResult

isMetadataSortDesc

isMetadataSortAsc

getDatabasePrepareStatements

explicitSetCollation

getDelimiter

buildRemoteURL

createSequenceHandler

injectComputedColumns