Page MenuHomePhabricator

Duplicated indexes (Postgres)
Closed, ResolvedPublic

Description

Author: overlordq

Description:
Dont know why I never noticed it before, but between tables.sql and updaters.inc they both specify an index with the same values but each calls it a different thing:

tables.sql:
CREATE INDEX rc_timestamp_bot ON recentchanges (rc_timestamp) WHERE rc_bot = 0;

updaters.inc:
array("recentchanges", "rc_timestamp_nobot", "(rc_timestamp) WHERE rc_bot = 0"),

So either/or should probably be changed to reflect the same name.


Version: 1.15.x
Severity: enhancement

Details

Reference
bz17581

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
InvalidNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:33 PM
bzimport set Reference to bz17581.
bzimport added a subscriber: Unknown Object (MLST).
Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.