rdbms: Remove support for PostgreSQL < 9.2, and improve INSERT IGNORE for 9.5
authorBrad Jorsch <bjorsch@wikimedia.org>
Sun, 18 Mar 2018 00:29:31 +0000 (20:29 -0400)
committerAaron Schulz <aschulz@wikimedia.org>
Thu, 5 Apr 2018 20:52:46 +0000 (20:52 +0000)
commitcc0473766a53bdb18ae52a7a2271c6fae49e3105
tree85e91f963a163a7321ff51c346b89dc227be1fb6
parentea62a9780c72fd24097c7e1bcff754aea33054e9
rdbms: Remove support for PostgreSQL < 9.2, and improve INSERT IGNORE for 9.5

MediaWiki doesn't support PostgreSQL < 9.2, so drop the support for
older versions.

At the same time, since we're messing with the DatabasePostgres::insert()
code anyway, let's start using ON CONFLICT DO NOTHING for PG >= 9.5.

And since we're doing that, let's do the same for
DatabasePostgres::nativeInsertSelect().

Change-Id: I7bf13c3272917ebafeaff11eb116714a099afdf3
RELEASE-NOTES-1.31
includes/libs/rdbms/database/Database.php
includes/libs/rdbms/database/DatabasePostgres.php
includes/libs/rdbms/database/utils/SavepointPostgres.php
maintenance/postgres/archives/patch-ts2pagetitle.sql
maintenance/postgres/tables.sql
tests/phpunit/includes/db/DatabasePostgresTest.php [new file with mode: 0644]