org.makumba.db.makumba.sql
Class PgsqlTableManager

java.lang.Object
  org.makumba.db.makumba.Table
      org.makumba.db.makumba.sql.TableManager
          org.makumba.db.makumba.sql.PgsqlTableManager

Direct Known Subclasses:

PgsqlOldTableManager

public class PgsqlTableManager
extends TableManager

Author:

Bart TODO To change the template for this generated type comment go to Window - Preferences - Java - Code Style - Code Templates

Nested Class Summary

Nested classes/interfaces inherited from class org.makumba.db.makumba.sql.TableManager

TableManager.CatalogChecker, TableManager.CheckingStrategy

Field Summary

Fields inherited from class org.makumba.db.makumba.sql.TableManager

admin, alter, checkDuplicate, checkNullDuplicate, dbsv, exists_, extraIndexes, foreignKeys, handlerExist, handlerList, handlerListAutoIncrement, indexDBField, indexes, indexField, keyIndex, modTable, parsedForeignKeys, preparedDeleteFromIgnoreDbsvString, preparedDeleteFromString, preparedDeleteString, preparedInsertAutoIncrementString, preparedInsertString, primaryKeyCurrentIndex, sqlDateFormat, tbname

Fields inherited from class org.makumba.db.makumba.Table

dd

Constructor Summary

PgsqlTableManager()

Method Summary

protected boolean	check_char_Width(String fieldName, ResultSetMetaData rsm, int index) postgres can't check char width, we return true
protected String	getFieldDBType(String fieldName) returns Postgres TEXT
protected int	getSQLType(String fieldName) what is the SQL type of this field?
void	setArgument(String fieldName, PreparedStatement ps, int n, Object o) set a non-null argument of this type in a prepared SQL statement

Methods inherited from class org.makumba.db.makumba.sql.TableManager

alter, alter, base_getValue, base_inCreate, base_setInsertArgument, base_toSQLObject, base_unmodified, base_writeConstant, canAdmin, check_char_Width, check_timeStamp_ValueImpl, checkCopy, checkDuplicate, checkDuplicate, checkInsert, checkStructure, checkUpdate, close, create, createDbSpecific, deleteFrom, deleteRecord, doAlter, exists, exists, fieldList, fillResult, fillResult, findDuplicates, findMultiFieldMultiTableDuplicates, foreignKeyCreateSyntax, get_binary_FieldDBType, get_binary_SQLType, get_binary_Value, get_boolean_FieldDBType, get_boolean_SQLType, get_boolean_Value, get_char_FieldDBType, get_char_SQLType, get_char_Value, get_dateTime_FieldDBType, get_dateTime_SQLType, get_dateTime_Value, get_int_FieldDBType, get_int_SQLType, get_int_Value, get_nil_Value, get_ptrDB_FieldDBType, get_ptrDB_SQLType, get_ptrDB_Value, get_real_FieldDBType, get_real_SQLType, get_text_FieldDBType, get_text_Value, get_timeStamp_FieldDBType, get_timeStamp_SQLType, get_timeStamp_Value, getColumnAlterKeyword, getCreateAutoIncrementSyntax, getDBName, getEngineProperty, getFieldDBIndexName, getFieldDBName, getFieldDBType, getQueryAutoIncrementSyntax, getSQLDatabase, getTableMissingStateName, getValue, getValue, hasForeignKey, in_boolean_Create, in_char_Create, inCondition, inCreate, indexCreated, indexCreateSyntax, indexCreateUniqueSyntax, indexCreateUniqueSyntax, indexDropSyntax, initFields, inPreparedInsert, inPreparedUpdate, insertRecordImpl, isIndexOk, isIndexOk, makeKeyIndex, manageForeignKeys, manageIndexes, nextId_ptrIndex, nxt_ptrIndex, nxt, onStartup, open, prepareDelete, prepareInsert, resetPrimaryKey, set_binary_Argument, set_text_Argument, set_timeStamp_InsertArgument, setCopyArgument, setInsertArgument, setNullArgument, setTableAndFieldNames, setUpdateArgument, setUpdateArgument, setValue, setValue, should_text_Index, shouldIndex, toSQL_dateTime_Object, toSQL_ptrDB_Object, toSQLObject, unmodified_char, unmodified_wrapper, unmodified, updateRecord, usesHidden, write_binary_Constant, write_boolean_Constant, write_char_Constant, write_dateTime_Constant, write_text_Constant, write_timeStamp_Constant, writeConstant

Methods inherited from class org.makumba.db.makumba.Table

getDatabase, getDataDefinition, getFieldDefinition, getRelatedTable, insertRecord, setDataDefinition

Methods inherited from class java.lang.Object

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

Constructor Detail

PgsqlTableManager

public PgsqlTableManager()

Method Detail

check_char_Width

protected boolean check_char_Width(String fieldName,
                                   ResultSetMetaData rsm,
                                   int index)
                            throws SQLException

postgres can't check char width, we return true

Overrides:

check_char_Width in class TableManager

Throws:

SQLException

getFieldDBType

protected String getFieldDBType(String fieldName)

returns Postgres TEXT

Overrides:

getFieldDBType in class TableManager

getSQLType

protected int getSQLType(String fieldName)

Description copied from class: TableManager

what is the SQL type of this field?

Overrides:

getSQLType in class TableManager

setArgument

public void setArgument(String fieldName,
                        PreparedStatement ps,
                        int n,
                        Object o)
                 throws SQLException

Description copied from class: TableManager

set a non-null argument of this type in a prepared SQL statement

Overrides:

setArgument in class TableManager

Throws:

SQLException