Last modified: 2011-10-12 01:16:47 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T3295, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 1295 - PostgreSQL table definitions
PostgreSQL table definitions
Status: RESOLVED DUPLICATE of bug 385
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
All All
: Normal normal (vote)
: ---
Assigned To: Greg Sabino Mullane
: 1391 (view as bug list)
Depends on:
Blocks: postgres
  Show dependency treegraph
Reported: 2005-01-09 08:48 UTC by Ian Barwick
Modified: 2011-10-12 01:16 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Patch for maintenance/postgresql/pg_tables.sql (783 bytes, patch)
2005-01-09 08:49 UTC, Ian Barwick
Adds page, text, and revision tables (1.68 KB, patch)
2005-01-20 22:04 UTC, Matt Adam
Adds page, text, and revision, and "group" tables (1.07 KB, patch)
2005-01-20 22:08 UTC, Matt Adam
Postgres schema, based on tables.sql version 1.93 (2.96 KB, application/x-gzip)
2006-04-12 00:17 UTC, Greg Sabino Mullane

Description Ian Barwick 2005-01-09 08:48:15 UTC
The table definition for "user_rights" is incorrect.
Comment 1 Ian Barwick 2005-01-09 08:49:49 UTC
Created attachment 200 [details]
Patch for maintenance/postgresql/pg_tables.sql

Brings pg_tables.sql back into line with the MySQL definitions.
Comment 2 Matt Adam 2005-01-20 22:04:39 UTC
Created attachment 209 [details]
Adds page, text, and revision tables
Comment 3 Matt Adam 2005-01-20 22:05:29 UTC
(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.
Comment 4 Matt Adam 2005-01-20 22:08:18 UTC
Created attachment 210 [details]
Adds page, text, and revision, and "group" tables
Comment 5 Brion Vibber 2005-10-08 01:04:03 UTC
Removing patch keyword; definitions in patch are out of date again.
Comment 6 Greg Sabino Mullane 2006-04-12 00:17:58 UTC
Created attachment 1515 [details]
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.
Comment 7 Greg Sabino Mullane 2006-04-12 00:37:39 UTC
*** Bug 1391 has been marked as a duplicate of this bug. ***
Comment 8 Greg Sabino Mullane 2006-04-12 03:29:41 UTC

*** This bug has been marked as a duplicate of 385 ***

Note You need to log in before you can comment on or make changes to this bug.