Page MenuHomePhabricator

PostgreSQL table definitions
Closed, ResolvedPublic

Description

Author: barwick

Description:
The table definition for "user_rights" is incorrect.


Version: 1.6.x
Severity: normal

Details

Reference
bz1295
TitleReferenceAuthorSource BranchDest Branch
Bump the version of the datahub packaged environmentrepos/data-engineering/airflow-dags!473btullisbump_datahub_versionmain
Update the schema registry used for airflow lineage in testrepos/data-engineering/airflow-dags!454btullisupdate_schema_registry_datahub_stagingmain
Fixed copy link feature mobile viewtoolforge-repos/wiki-gpt!15isarantowiki-gpt-mainmain
Fixed copy link feature mobile viewtoolforge-repos/wiki-gpt!14kevinbaziramainmain
Customize query in GitLab

Revisions and Commits

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
ResolvedTurnstep

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 8:10 PM
bzimport set Reference to bz1295.

barwick wrote:

Patch for maintenance/postgresql/pg_tables.sql

Brings pg_tables.sql back into line with the MySQL definitions.

attachment pg_tables.sql.diff ignored as obsolete

matt wrote:

Adds page, text, and revision tables

attachment pg_tables_new_tables.patch ignored as obsolete

matt wrote:

(whoops, the above patch was submitted by myself)

I'm new to the mediawiki sources, but I thought I'd help with this effort
because I want to run mediawiki on a machine with PostgreSQL. I believe the
table definitions in CVS need more updating, to match the changes that happened
in maintenance/tables.sql, revision 1.42. Namely, the page, text, and revision
relations are missing.

I have taken a first stab at modifying pg_tables.sql and pg_users.sql to add these.

matt wrote:

Adds page, text, and revision, and "group" tables

attachment pg_users_new_tables.patch ignored as obsolete

Removing patch keyword; definitions in patch are out of date again.

Created attachment 1515
Postgres schema, based on tables.sql version 1.93

This requires a new directory underneath maintenance called "postgres". It also
requires a separate patch to integrate PG into the installation process, but
should satisfy this bug.

Attached:

  • Bug 1391 has been marked as a duplicate of this bug. ***
  • This bug has been marked as a duplicate of 385 ***
Diffusion added a commit: Unknown Object (Diffusion Commit).Mar 4 2015, 8:21 AM
Jdforrester-WMF subscribed.

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