docs/databases/postgres.txt File Reference

Functions
This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of but without copying over all the usage comments General notes on the but these can almost always be programmed around *Although Postgres has a true BOOLEAN boolean columns are always mapped to as the code does not always treat the column as a	boolean (which is limited to accepting true, false, 0, 1, t, or f) *The default data type for all VARCHAR

Variables
This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of but without copying over all the usage comments General notes on the but these can almost always be programmed around *Although Postgres has a true BOOLEAN boolean columns are always mapped to as the code does not always treat the column as a	CHAR
This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of but without copying over all the usage comments General notes on the	conversion
This document describes the state of Postgres support in and is fairly well maintained The main code is very well	integrated
This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of	life
This document describes the state of Postgres support in	MediaWiki
This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of but without copying over all the usage comments General notes on the but these can almost always be programmed around *Although Postgres has a true BOOLEAN boolean columns are always mapped to	SMALLINT
This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss	Still
This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres	support
This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of but without copying over all the usage comments General notes on the but these can almost always be programmed around *Although Postgres has a true BOOLEAN	type

Function Documentation

boolean()

This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of but without copying over all the usage comments General notes on the but these can almost always be programmed around* Although Postgres has a true BOOLEAN boolean columns are always mapped to as the code does not always treat the column as a boolean	(	which is limited to accepting	true,
		false	,
		0	,
		1	,
		t	,
		or	f
	)

Variable Documentation

CHAR

This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of but without copying over all the usage comments General notes on the but these can almost always be programmed around* Although Postgres has a true BOOLEAN boolean columns are always mapped to as the code does not always treat the column as a CHAR

Definition at line 41 of file postgres.txt.

conversion

This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of but without copying over all the usage comments General notes on the conversion

Definition at line 22 of file postgres.txt.

integrated

This document describes the state of Postgres support in and is fairly well maintained The main code is very well integrated

Definition at line 4 of file postgres.txt.

life

This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of life

Initial value:

== Database schema ==
 
Postgres has its own schema file at maintenance/postgres/tables.sql.
 
The goal is to keep this file as close as possible to the canonical
schema at maintenance/tables.sql

Definition at line 22 of file postgres.txt.

MediaWiki

those of us who don t want or need it can just leave it out The extensions don t even have to be shipped with MediaWiki

Initial value:

== Overview ==
 
Support for PostgreSQL has been available since version 1.7
of MediaWiki

Definition at line 4 of file postgres.txt.

Referenced by MediaWikiTest::testPostSendJobDoesNotSetCookie(), and MediaWikiTest::testTryNormaliseRedirect().

SMALLINT

This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of but without copying over all the usage comments General notes on the but these can almost always be programmed around* Although Postgres has a true BOOLEAN boolean columns are always mapped to SMALLINT

Definition at line 22 of file postgres.txt.

Still

This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss Still

Definition at line 4 of file postgres.txt.

support

This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres support

Initial value:

== Required versions ==
 
The current minimum version of PostgreSQL for MediaWiki is 8.1.
It is expected that this will be raised to 8.3 at some point

Definition at line 14 of file postgres.txt.

type

< input type="submit" name="fulltext" class="mw-ui-button" value="Search full text"/></form ></div > ! end ! test InputBox type

Definition at line 22 of file postgres.txt.

Referenced by MediaWiki\Widget\DateTimeInputWidget::__construct(), PoolCounterWork::__construct(), ChangesFeed::__construct(), ProtectedPagesPager::__construct(), SearchIndexFieldDefinition::__construct(), JobQueue::__construct(), JobSpecification::__construct(), MediaWiki\Auth\Throttler::__construct(), LogPage::__construct(), Exif::__construct(), Site::__construct(), ChangesListFilterGroup::__construct(), ManualLogEntry::__construct(), JSNode::__construct(), LogPage::addEntry(), JobQueueDB::claimOldest(), JobQueueDB::claimRandom(), MediaWiki\Auth\Throttler::clear(), JobQueueRedis::doAck(), JobQueueDB::doAck(), JobQueueRedis::doBatchPush(), JobQueueDB::doBatchPushInternal(), JobQueueMemory::doDelete(), JobQueueDB::doDelete(), JobQueueDB::doIsEmpty(), JobQueueDB::doPop(), JobQueueRedis::doPop(), JobQueueRedis::encodeQueueName(), SpecialUnblock::execute(), UpdateLogging::execute(), ChangesFeed::execute(), SkinFallbackTemplate::execute(), JSParser::Expression(), JobQueueDB::getCacheKey(), SpecialUnblock::getFields(), MediaWiki\Widget\DateTimeInputWidget::getInputElement(), File::getIsSafeFileUncached(), RedisLockManager::getLocksOnServer(), ProtectedPagesPager::getQueryInfo(), JobQueueMemory::getQueueData(), Block::getRangeEnd(), Block::getRangeStart(), JobQueue::getRootJobCacheKey(), Gadget::getType(), MediaWiki\Auth\Throttler::increase(), SpecialBlock::maybeAlterFormDefaults(), SearchIndexFieldDefinition::merge(), Block::newLoad(), JobQueue::pop(), JobQueueDB::recycleAndDeleteStaleJobs(), LogPage::saveContent(), SpecialBlock::setParameter(), Block::setTarget(), WikiRevision::setType(), LogEventsList::showLogExtract(), and JSParser::Statement().