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


Summary:	PostgreSQL table definitions

Status:	RESOLVED DUPLICATE of bug 385

Product:	MediaWiki
Classification:	Unclassified
Component:	Installer (Other open bugs)
Version:	1.6.x
Hardware:	All All

Importance:	Normal normal (vote)
Target Milestone:	---
Assigned To:	Greg Sabino Mullane

URL:
Whiteboard:
Keywords:

Duplicates:	1391 (view as bug list)
Depends on:
Blocks:	postgres
	Show dependency tree / graph

Reported:	2005-01-09 08:48 UTC by Ian Barwick
Modified:	2011-10-12 01:16 UTC (History)
CC List:	3 users (show)

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

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

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 ***

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links