https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Bug 15441 depends on bug 33638, which changed state.
Bug 33638 Summary: Math table doesn't have a PK
https://bugzilla.wikimedia.org/show_bug.cgi?id=33638
What|Removed |Added
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Nathan Larson nathanlarson3...@gmail.com changed:
What|Removed |Added
Depends on||71198
--
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Liangent liang...@gmail.com changed:
What|Removed |Added
See Also|
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Brad Jorsch bjor...@wikimedia.org changed:
What|Removed |Added
Blocks||65264
--
You are
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Andre Klapper aklap...@wikimedia.org changed:
What|Removed |Added
Status|PATCH_TO_REVIEW |NEW
--- Comment
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Daniel Kinzler daniel.kinz...@wikimedia.de changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Gerrit Notification Bot gerritad...@wikimedia.org changed:
What|Removed |Added
Status|NEW
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #22 from Gerrit Notification Bot gerritad...@wikimedia.org ---
Change 51675 merged by jenkins-bot:
Add archive, externallinks PK
https://gerrit.wikimedia.org/r/51675
--
You are receiving this mail because:
You are on the CC list
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #19 from Domas Mituzas domas.mitu...@gmail.com ---
There are no global/database/table locking implications with hidden row key. It
does not have to be synchronized with any other subsystem, so the cost of
row-id is zero. Adding
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #20 from Tyler Romeo tylerro...@gmail.com ---
(In reply to comment #19)
There are no global/database/table locking implications with hidden row key.
It
does not have to be synchronized with any other subsystem, so the cost of
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Sean Pringle sprin...@wikimedia.org changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #18 from Tyler Romeo tylerro...@gmail.com ---
If this is being actively worked on, I'd like to note one other thing that
should probably be changed along with this: a lot of our tables have primary
keys, but also don't at the same
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
MZMcBride b...@mzmcbride.com changed:
What|Removed |Added
CC||b...@mzmcbride.com
--
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Nathan Larson nathanlarson3...@gmail.com changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Brylie Oxley bry...@gnumedia.org changed:
What|Removed |Added
Keywords||postgresql,
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Asher Feldman afeld...@wikimedia.org changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #14 from Domas Mituzas domas.mitu...@gmail.com 2012-01-15
14:15:41 UTC ---
small note: we don't use workbench to edit data in WMF deployment, and we
shouldn't ;-)
--
Configure bugmail:
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #15 from Joerg mueller062001-...@yahoo.de 2012-01-15 23:01:52 UTC
---
Workbench was just an example. I know that you prefer the command line. ;-)
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #8 from Fabien Coelho wikimedia@coelho.net 2012-01-13
10:11:49 UTC ---
(In reply to comment #5)
Obviously fixing the ones with no PK or unique key is more easily done
ISTM that you are a little bit optimistic here. If the
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #9 from Fabien Coelho wikimedia@coelho.net 2012-01-13
10:20:33 UTC ---
(In reply to comment #7)
Is there a nice way to convert a unique key to a PK without having to drop and
re-add it?
AFAIK, not for PostgreSQL.
For the
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #10 from Joerg mueller062001-...@yahoo.de 2012-01-13 13:41:58 UTC
---
I could not find anything on changing an existing index into a PK in the MySQL
docs.
Also professional DB Tools like MySQL GUI Tools, MySQL Workbench (and also
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #11 from Sam Reed (reedy) s...@reedyboy.net 2012-01-13 17:02:36
UTC ---
(In reply to comment #10)
This is an according example output:
ALTER TABLE `x`
ADD PRIMARY KEY (`field`),
DROP INDEX `field`;
On that note, someone
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #12 from Tim Landscheidt t...@tim-landscheidt.de 2012-01-14
00:33:33 UTC ---
(In reply to comment #9)
Is there a nice way to convert a unique key to a PK without having to drop
and
re-add it?
AFAIK, not for PostgreSQL.
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #13 from Fabien Coelho wikimedia@coelho.net 2012-01-14
06:52:36 UTC ---
(In reply to comment #12)
There seems to be a way described at
http://archives.postgresql.org/pgsql-general/2004-12/msg01161.php. On any
database
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #4 from Joerg mueller062001-...@yahoo.de 2012-01-12 15:43:31 UTC
---
It is important that really Primary Keys are used and not just any index.
Otherwise you might get into trouble trying to edit table data. Programmes like
MySQL
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #5 from Reedy s...@reedyboy.net 2012-01-12 17:47:23 UTC ---
(In reply to comment #4)
It is important that really Primary Keys are used and not just any index.
Otherwise you might get into trouble trying to edit table data.
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #6 from Joerg mueller062001-...@yahoo.de 2012-01-12 19:36:55 UTC
---
No, he did not. Basically what I wrote above is everything he told me.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Reedy s...@reedyboy.net changed:
What|Removed |Added
Priority|Low |Normal
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Reedy s...@reedyboy.net changed:
What|Removed |Added
CC||s...@reedyboy.net
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Reedy s...@reedyboy.net changed:
What|Removed |Added
Depends on||33638
--
Configure bugmail:
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #2 from Reedy s...@reedyboy.net 2012-01-10 14:23:49 UTC ---
No PK (but has unique index):
categorylinks
change_tag
imagelinks
interwiki
iwlinks
langlinks
log_search
module_deps
msg_resource
msg_resource_links
page_props
oagelinks
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Reedy s...@reedyboy.net changed:
What|Removed |Added
CC||mueller062001-...@yahoo.de
32 matches
Mail list logo
