From what I can see, various changes to the Postgres DB Updater have been mixed in with the 1.35 ones... And no 1.36 section has been added
From `git diff REL1_35...master includes/installer/PostgresUpdater.php`
```lang=diff
diff --git a/includes/installer/PostgresUpdater.php b/includes/installer/PostgresUpdater.php
index 328e1abe2a..8f8afc5b5f 100644
--- a/includes/installer/PostgresUpdater.php
+++ b/includes/installer/PostgresUpdater.php
@@ -225,7 +225,6 @@ class PostgresUpdater extends DatabaseUpdater {
[ 'changeField', 'revision', 'rev_deleted', 'smallint', 'rev_deleted::smallint DEFAULT 0' ],
[ 'changeField', 'revision', 'rev_minor_edit', 'smallint',
'rev_minor_edit::smallint DEFAULT 0' ],
- [ 'changeField', 'templatelinks', 'tl_namespace', 'smallint', 'tl_namespace::smallint' ],
[ 'changeField', 'user_newtalk', 'user_ip', 'text', 'host(user_ip)' ],
[ 'changeField', 'uploadstash', 'us_image_bits', 'smallint', '' ],
@@ -247,12 +246,10 @@ class PostgresUpdater extends DatabaseUpdater {
[ 'addPgIndex', 'ipblocks', 'ipb_parent_block_id', '(ipb_parent_block_id)' ],
[ 'addPgIndex', 'oldimage', 'oi_sha1', '(oi_sha1)' ],
[ 'addPgIndex', 'page', 'page_mediawiki_title', '(page_title) WHERE page_namespace = 8' ],
- [ 'addPgIndex', 'pagelinks', 'pagelinks_title', '(pl_title)' ],
[ 'addPgIndex', 'page_props', 'pp_propname_page', '(pp_propname, pp_page)' ],
[ 'ifFieldExists', 'revision', 'rev_text_id',
'addPgIndex', 'revision', 'rev_text_id_idx', '(rev_text_id)' ],
[ 'addPgIndex', 'recentchanges', 'rc_timestamp_bot', '(rc_timestamp) WHERE rc_bot = 0' ],
- [ 'addPgIndex', 'templatelinks', 'templatelinks_from', '(tl_from)' ],
[ 'addPgIndex', 'watchlist', 'wl_user', '(wl_user)' ],
[ 'addPgIndex', 'watchlist', 'wl_user_notificationtimestamp',
'(wl_user, wl_notificationtimestamp)' ],
@@ -271,12 +268,6 @@ class PostgresUpdater extends DatabaseUpdater {
[ 'ifTableNotExists', 'actor', 'addPgIndex', 'logging', 'logging_user_text_time',
'(log_user_text, log_timestamp)' ],
- [ 'checkIndex', 'pagelink_unique', [
- [ 'pl_from', 'int4_ops', 'btree', 0 ],
- [ 'pl_namespace', 'int2_ops', 'btree', 0 ],
- [ 'pl_title', 'text_ops', 'btree', 0 ],
- ],
- 'CREATE UNIQUE INDEX pagelink_unique ON pagelinks (pl_from,pl_namespace,pl_title)' ],
[ 'checkIndex', 'cl_sortkey', [
[ 'cl_to', 'text_ops', 'btree', 0 ],
[ 'cl_sortkey', 'text_ops', 'btree', 0 ],
@@ -376,7 +367,6 @@ class PostgresUpdater extends DatabaseUpdater {
'mwuser(user_id) ON DELETE SET NULL' ],
[ 'ifTableNotExists', 'actor', 'changeFkeyDeferrable', 'image', 'img_user',
'mwuser(user_id) ON DELETE SET NULL' ],
- [ 'changeFkeyDeferrable', 'imagelinks', 'il_from', 'page(page_id) ON DELETE CASCADE' ],
[ 'ifTableNotExists', 'actor', 'changeFkeyDeferrable', 'ipblocks', 'ipb_by',
'mwuser(user_id) ON DELETE CASCADE' ],
[ 'changeFkeyDeferrable', 'ipblocks', 'ipb_user', 'mwuser(user_id) ON DELETE SET NULL' ],
@@ -401,7 +391,6 @@ class PostgresUpdater extends DatabaseUpdater {
[ 'changeFkeyDeferrable', 'revision', 'rev_page', 'page (page_id) ON DELETE CASCADE' ],
[ 'ifFieldExists', 'revision', 'rev_text_id',
'changeFkeyDeferrable', 'revision', 'rev_user', 'mwuser(user_id) ON DELETE RESTRICT' ],
- [ 'changeFkeyDeferrable', 'templatelinks', 'tl_from', 'page(page_id) ON DELETE CASCADE' ],
[ 'changeFkeyDeferrable', 'user_groups', 'ug_user', 'mwuser(user_id) ON DELETE CASCADE' ],
[ 'changeFkeyDeferrable', 'user_newtalk', 'user_id', 'mwuser(user_id) ON DELETE CASCADE' ],
[ 'changeFkeyDeferrable', 'user_properties', 'up_user',
@@ -697,6 +686,52 @@ class PostgresUpdater extends DatabaseUpdater {
[ 'changeField', 'actor', 'actor_name', 'TEXT', '' ],
[ 'changeField', 'user_former_groups', 'ufg_group', 'TEXT', '' ],
[ 'dropFkey', 'user_former_groups', 'ufg_user' ],
+ [ 'setDefault', 'bot_passwords', 'bp_token', '' ],
+ [ 'changeField', 'comment', 'comment_id', 'BIGINT', '' ],
+ [ 'changeField', 'slots', 'slot_revision_id', 'BIGINT', '' ],
+ [ 'changeField', 'slots', 'slot_content_id', 'BIGINT', '' ],
+ [ 'changeField', 'slots', 'slot_origin', 'BIGINT', '' ],
+ [ 'changeField', 'site_stats', 'ss_total_edits', 'BIGINT', '' ],
+ [ 'changeField', 'site_stats', 'ss_good_articles', 'BIGINT', '' ],
+ [ 'changeField', 'site_stats', 'ss_total_pages', 'BIGINT', '' ],
+ [ 'changeField', 'site_stats', 'ss_users', 'BIGINT', '' ],
+ [ 'changeField', 'site_stats', 'ss_active_users', 'BIGINT', '' ],
+ [ 'changeField', 'site_stats', 'ss_images', 'BIGINT', '' ],
+ [ 'dropFkey', 'user_properties', 'up_user' ],
+ [ 'addIndex', 'user_properties', 'user_properties_pkey', 'patch-user_properties-pk.sql' ],
+ [ 'changeField', 'log_search', 'ls_value', 'VARCHAR(255)', '' ],
+ [ 'changeField', 'content', 'content_id', 'BIGINT', '' ],
+ [ 'changeField', 'l10n_cache', 'lc_value', 'TEXT', '' ],
+ [ 'changeField', 'l10n_cache', 'lc_key', 'VARCHAR(255)', '' ],
+ [ 'addIndex', 'l10n_cache', 'l10n_cache_pkey', 'patch-l10n_cache-pk.sql' ],
+ [ 'addIndex', 'module_deps', 'module_deps_pkey', 'patch-module_deps-pk.sql' ],
+ [ 'changeField', 'redirect', 'rd_namespace', 'INT', 'rd_namespace::INT DEFAULT 0' ],
+ [ 'setDefault', 'redirect', 'rd_title', '' ],
+ [ 'setDefault', 'redirect', 'rd_from', 0 ],
+ [ 'dropFkey', 'redirect', 'rd_from' ],
+ [ 'changeField', 'redirect', 'rd_interwiki', 'VARCHAR(32)', '' ],
+ [ 'dropFkey', 'pagelinks', 'pl_from' ],
+ [ 'changeField', 'pagelinks', 'pl_namespace', 'INT', 'pl_namespace::INT DEFAULT 0' ],
+ [ 'setDefault', 'pagelinks', 'pl_title', '' ],
+ [ 'addPgIndex', 'pagelinks', 'pl_namespace', '(pl_namespace,pl_title,pl_from)' ],
+ [ 'addPgIndex', 'pagelinks', 'pl_backlinks_namespace',
+ '(pl_from_namespace,pl_namespace,pl_title,pl_from)' ],
+ [ 'dropPgIndex', 'pagelinks', 'pagelink_unique' ],
+ [ 'dropPgIndex', 'pagelinks', 'pagelinks_title' ],
+ [ 'dropFkey', 'templatelinks', 'tl_from' ],
+ [ 'changeField', 'templatelinks', 'tl_namespace', 'INT', 'tl_namespace::INT DEFAULT 0' ],
+ [ 'setDefault', 'templatelinks', 'tl_title', '' ],
+ [ 'addPgIndex', 'templatelinks', 'tl_namespace', '(tl_namespace,tl_title,tl_from)' ],
+ [ 'addPgIndex', 'templatelinks', 'tl_backlinks_namespace',
+ '(tl_from_namespace,tl_namespace,tl_title,tl_from)' ],
+ [ 'dropPgIndex', 'templatelinks', 'templatelinks_unique' ],
+ [ 'dropPgIndex', 'templatelinks', 'templatelinks_from' ],
+ [ 'dropFkey', 'imagelinks', 'il_from' ],
+ [ 'setDefault', 'imagelinks', 'il_to', '' ],
+ [ 'addPgIndex', 'imagelinks', 'il_to', '(il_to, il_from)' ],
+ [ 'addPgIndex', 'imagelinks', 'il_backlinks_namespace',
+ '(il_from_namespace, il_to, il_from)' ],
+ [ 'dropPgIndex', 'imagelinks', 'il_from' ],
];
}
```