provides the PostgreSQL-specific implementation of the SqlUtil::AbstractTable interface
More...
|
| constructor (AbstractDatasource nds, string nname, *hash opts) |
| Creates the object from the arguments.
|
|
string | getColumnSqlName (string col) |
| returns the column name for use in SQL strings; subclasses can return a special string in case the column name is a reserved word
|
|
list< auto > | getColumnSqlNames (softlist< auto > cols) |
| returns a list of column names for use in SQL strings
|
|
hash< auto > | getExpressionMap () |
| Returns the expression map for PostgreSQL.
|
|
string | getSchemaName () |
| returns the schema name
|
|
string | getSqlName () |
| returns the name of the table to be used in SQL (with a possible qualifiers for schema, etc)
|
|
*string | getTablespaceName () |
| returns the data tablespace name for the table or nothing if none is known
|
|
code | getUpsertClosure (hash< auto > row, int upsert_strategy=UpsertAuto, *hash< auto > opt) |
| returns a closure for performing upserts
|
|
bool | hasArrayBind () |
| returns False because the pgsql driver does not support array binds / bulk DML operations
|
|
bool | hasAtomicUpsert () |
| Returns True if the server supports atomic upsert/merge operations.
|
|
|
const | PgsqlCopMap = ... |
| column operator specializations for PostgreSQL
|
|
const | PgsqlExpressionMap = ... |
| Expression map for PostgreSQL.
|
|
const | PgsqlIopMap = ... |
| a hash of default value operator descriptions for PostgreSQL
|
|
const | PgsqlNameMap = ... |
| maps from verbose type names to simple type names
|
|
const | PgsqlTableDescriptionHashOptions = ... |
| extends SqlUtil::AbstractTable::TableDescriptionHashOptions with "functions"
|
|
const | PgsqlTruncDate = ... |
| Map SqlUtil::cop_trunc_date() constants to PostgreSQL internal masks.
|
|
const | PgsqlTypeMap = ... |
| maps PostgreSQL type names to type configurations
|
|
const | PgsqlUopMap = ... |
| a hash of default update operator definitions for PostgreSQL
|
|
const | QoreTypeMap = ... |
| maps qore type names to PostgreSQL type names
|
|
|
| clearImpl () |
| clears PostgreSQL-specific table information
|
|
bool | constraintsLinkedToIndexesImpl () |
| returns True if the database links constraints to indexes (ie dropping the constraint drops the index, etc)
|
|
| copyImpl (AbstractTable old) |
| db-specific copy actions
|
|
| doSelectLimitOnlyInternImpl (reference< hash< QueryInfo > > info, reference< string > sql) |
| processes a string for use in SQL select statements when there is a "limit" argument, but no "orderby" or "offset" arguments
|
|
| doSelectOrderByWithOffsetSqlInternImpl (reference< hash< QueryInfo > > info, reference< string > sql, list< auto > coll) |
| processes a string for use in SQL select statements when there is an "order by" and "offset" argument
|
|
hash | getColumnOperatorMapImpl () |
| returns the column operator map for this object
|
|
string | getCreateSqlImpl (list l) |
| returns a string that can be used to create the table in the database
|
|
string | getCreateTableSqlImpl (*hash opt) |
| returns a string that can be used to create the table in the database
|
|
hash | getInsertOperatorMap () |
| returns the insert operator map for this object
|
|
AbstractDataProviderType | getNumericTypeImpl (string native_type, bool nullable, *hash< auto > options) |
| returns the type for number / numeric columns for the database so that data conversions can be handled properly
|
|
hash | getRawUpdateOperatorMap () |
| returns the raw (default) update operator map for this object
|
|
AbstractSavepointHelper | getSavepointHelperImpl (*string savepoint) |
| get DB-specific savepoint helper
|
|
| getServerVersion () |
| Sets the internal PostgreSQL server version.
|
|
*string | getSqlValueImpl (auto v) |
| returns a string for use in SQL queries representing the DB-specific value of the argument
|
|
bool | isDuplicateRowErrorImpl (hash< ExceptionInfo > ex) |
| Returns True if the exception was raised because of a duplicate row / key error.
|
|
transient Mutex | pg_state () |
| Lock for atomicity for setting state info.
|
|
bool | supportsTablespacesImpl () |
| returns True if the database support tablespaces
|
|
auto | tryExecArgsImpl (string sql, *softlist< auto > args) |
| tries to execute a command so that if an error occurs the current transaction status is not lost
|
|
auto | tryExecRawImpl (string sql, *softlist< auto > args) |
| tries to execute a command so that if an error occurs the current transaction status is not lost
|
|
bool | uniqueIndexCreatesConstraintImpl () |
| returns True if the database automatically creates a unique constraint when a unique index is created (ex: mysql)
|
|
provides the PostgreSQL-specific implementation of the SqlUtil::AbstractTable interface