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 changed:
What|Removed |Added
Depends on||71198
--
You are receiving this mail
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Brad Jorsch changed:
What|Removed |Added
Blocks||65264
--
You are receiving this mail be
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Liangent changed:
What|Removed |Added
See Also||https://bugzilla.wikimedia.
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Andre Klapper changed:
What|Removed |Added
Status|PATCH_TO_REVIEW |NEW
--- Comment #25 from Andre Klapper
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Daniel Kinzler changed:
What|Removed |Added
CC||daniel.kinz...@wikimedia.de
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Gerrit Notification Bot changed:
What|Removed |Added
Status|NEW |PATCH_TO_REVIEW
--
You are
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #22 from Gerrit Notification Bot ---
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 for the bug.
_
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #21 from Domas Mituzas ---
Oh, with that thinking I can point out fifty other global locks that are
touched when executing queries. The question is for what duration and are there
truly any locking implications there or do they appl
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #20 from Tyler Romeo ---
(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
> row-id is zero. Add
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #19 from Domas Mituzas ---
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 auto-increment key would inc
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #18 from Tyler Romeo ---
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 time. Basically, the m
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Sean Pringle changed:
What|Removed |Added
CC||sprin...@wikimedia.org
Assign
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
MZMcBride changed:
What|Removed |Added
CC||b...@mzmcbride.com
--
You are receiving t
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Nathan Larson changed:
What|Removed |Added
CC||nathanlarson3...@gmail.com
--- Comment
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Brylie Oxley changed:
What|Removed |Added
Keywords||postgresql, schema-change
--
Configure
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Asher Feldman changed:
What|Removed |Added
CC||afeld...@wikimedia.org
--- Comment #16
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #15 from Joerg 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
--- You are receiving this ma
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #14 from Domas Mituzas 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/userprefs.cgi?tab=email
--- You a
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #13 from Fabien Coelho 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 smaller than WMF's, I woul
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #12 from Tim Landscheidt 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.
There seems to be a
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #11 from Sam Reed (reedy) 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 was going to lo
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #10 from Joerg 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
phpMyAdmin) just DROP the o
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #9 from Fabien Coelho 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 order, it seems safer to
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #8 from Fabien Coelho 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 data do not really
comply t
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Reedy changed:
What|Removed |Added
Priority|Low |Normal
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #6 from Joerg 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 are receiving this mail bec
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #5 from Reedy 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. Programmes
> like
> My
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #4 from Joerg 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 Workbench do not allow you to
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Reedy changed:
What|Removed |Added
CC||mueller062001-...@yahoo.de
--- Comment #3 from
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #2 from Reedy 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
protected_titles
que
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Reedy changed:
What|Removed |Added
Depends on||33638
--
Configure bugmail: https://bugzilla.
https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Reedy changed:
What|Removed |Added
CC||s...@reedyboy.net
Version|1.12.x
33 matches
Mail list logo