joomla/joomla-platform — pull request #532 by gpongelli (2011-11-14 22:16:17+00:00)
Title: PostgreSQL driver for Joomla! platform.

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.
These two classes are tested by other two classes under "test" folder.

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
- transactionCommit, commit a transaction
- transactionRollback, rollback whole transaction or to a savepoint
- transactionSavepoint, creates transaction savepoint
- transactionStart, starts a transaction

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

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
- getInsertTable, used in "indertid()" to retrieve last INSERT INTO's table name
- lock, lock given table
- noWait, no wait a locked table
- returning, an INSERT INTO optional clause to returns last insert id
- unlock, unlock tables