Pending

User tests: Successful: Unsuccessful:

avatar gpongelli
gpongelli
12 Jan 2012

This driver implements inherited function from JDatabase class and add some other useful function to be able to use Joomla! on PostgreSQL database.
There is also a class that inherits from JDatabaseQuery to be able to create query object using PostgreSQL dialect.

PostgreSQL's added functions:

  • dropTable, drops given table
  • getRandom, ge a random number
  • getStringPositionSQL, returns string's position inside another string
  • releaseTransactionSavepoint, release given savepoint during transaction
  • renameTable, rename given table
  • showTables, lists all table in database

Overridden functions:

  • connected
  • escape
  • explain
  • fetchArray
  • fetchAssoc
  • fetchObject
  • freeResult
  • getAffectedRows
  • getAlterDbCharacterSet
  • getCollation
  • getCreateDbQuery
  • getNumRows
  • getQuery
  • getTableColumns
  • getTableCreate
  • getTableKeys
  • getTableList
  • getVersion
  • hasUTF
  • insertid
  • query
  • queryBatch
  • replacePrefix
  • select
  • setUTF
  • transactionCommit
  • transactionRollback
  • transactionSavepoint
  • transactionStart

PostgreSQL database query added functions:

  • limit, a possible replace for limit in setQuery
  • offset, a possible replace for limit in setQuery
  • forShare, lock table/row during SELECT
  • forUpdate, lock table/row during SELECT
  • noWait, no wait a locked table
  • returning, an INSERT INTO optional clause to returns last insert id
avatar gpongelli gpongelli - open - 12 Jan 2012
avatar gpongelli gpongelli - reference | - 25 Mar 12
avatar gpongelli
gpongelli - comment - 25 Mar 2012

Closing this pull request, updated version is pull 166 linked above.

avatar gpongelli gpongelli - close - 25 Mar 2012
avatar garyamort garyamort - reference | - 25 Oct 13

Add a Comment

Login with GitHub to post a comment