[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386 Krinkle krinklem...@gmail.com changed: What|Removed |Added Version|1.16.0 |1.16.x -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386 Tim Landscheidt t...@tim-landscheidt.de changed: What|Removed |Added Status|REOPENED|RESOLVED CC||t...@tim-landscheidt.de Resolution||FIXED --- Comment #9 from Tim Landscheidt t...@tim-landscheidt.de 2011-12-31 20:43:22 UTC --- Thanks for your report. PostgreSQL 8.1 reached its end of life in November 2010. While MediaWiki 1.16 may have been released before that time, this bug is now a dead horse. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386
Michael Tutty michael.tu...@iowa.gov changed:
What|Removed |Added
Status|RESOLVED|REOPENED
CC||michael.tu...@iowa.gov
Resolution|FIXED |
--- Comment #8 from Michael Tutty michael.tu...@iowa.gov 2011-02-03 21:24:58
UTC ---
The revision referenced above doesn't appear to work properly with my PG
8.1.21. Specifically, the ALTER TABLE tablename RENAME sequencename TO
newseqname seems to be written wrong. I was able to get the following to
work:
ALTER TABLE rev_rev_id_val RENAME TO revision_rev_id_seq;
ALTER TABLE revision ALTER COLUMN rev_id SET DEFAULT
NEXTVAL('revision_rev_id_seq');
ALTER TABLE text_old_id_val RENAME TO text_old_id_seq;
ALTER TABLE pagecontent ALTER COLUMN old_id SET DEFAULT
nextval('text_old_id_seq');
ALTER TABLE category_id_seq RENAME TO category_cat_id_seq;
ALTER TABLE category ALTER COLUMN cat_id SET DEFAULT
nextval('category_cat_id_seq');
ALTER TABLE ipblocks_ipb_id_val RENAME TO ipblocks_ipb_id_seq;
ALTER TABLE ipblocks ALTER COLUMN ipb_id SET DEFAULT
nextval('ipblocks_ipb_id_seq');
ALTER TABLE rc_rc_id_seq RENAME TO recentchanges_rc_id_seq;
ALTER TABLE recentchanges ALTER COLUMN rc_id SET DEFAULT
nextval('recentchanges_rc_id_seq');
ALTER TABLE log_log_id_seq RENAME TO logging_log_id_seq;
ALTER TABLE logging ALTER COLUMN log_id SET DEFAULT
nextval('logging_log_id_seq');
ALTER TABLE pr_id_val RENAME TO page_restrictions_pr_id_seq;
ALTER TABLE page_restrictions ALTER COLUMN pr_id SET DEFAULT
nextval('page_restrictions_pr_id_seq');
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386 OverlordQ overlo...@gmail.com changed: What|Removed |Added Status|ASSIGNED|RESOLVED Blocks||384 Resolution||FIXED --- Comment #7 from OverlordQ overlo...@gmail.com 2010-09-03 21:24:50 UTC --- Should be fixed with r72314 on master. Not yet merged to the 1.16 branch. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386 Chad H. innocentkil...@gmail.com changed: What|Removed |Added CC||canadien...@yahoo.ca --- Comment #5 from Chad H. innocentkil...@gmail.com 2010-09-01 19:23:47 UTC --- *** Bug 24738 has been marked as a duplicate of this bug. *** -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386 --- Comment #6 from OverlordQ overlo...@gmail.com 2010-09-01 20:14:04 UTC --- the update script uses RENAME SEQUENCE which appears to be 8.3+ instead of the more backwards compatible ALTER TABLE RENAME -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386 OverlordQ overlo...@gmail.com changed: What|Removed |Added Version|1.16-svn|1.16.0 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386 OverlordQ overlo...@gmail.com changed: What|Removed |Added CC||overlo...@gmail.com --- Comment #4 from OverlordQ overlo...@gmail.com 2010-03-01 01:24:22 UTC --- r58262 and r58263 Seems it missed release notes, did you run update? If the updaters didn't update the fields correctly then yes that's likely a bug, but afaik it worked fine during testing. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386 Greg Sabino Mullane g...@turnstep.com changed: What|Removed |Added Status|NEW |ASSIGNED --- Comment #3 from Greg Sabino Mullane g...@turnstep.com 2009-11-15 22:03:06 UTC --- I'm not clear on the history of events? What version was it created with, and did the upgrade a couple weeks later give any errors? (the upgrade command that is). -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386 Brion Vibber br...@pobox.com changed: What|Removed |Added AssignedTo|wikibugs- |g...@turnstep.com |l...@lists.wikimedia.org | -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386 --- Comment #1 from Niels Olson niels.ol...@gmail.com 2009-11-02 14:16:08 UTC --- Also, the postgres is from MacPorts, version 8.3.6, and the mediawiki is svn trunk. The error seems to have started with my latest checkout, which had a couple weeks of changes in it (due to being out service range in the middle of the Texas desert with a pack on my back) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 21386] Can't commit edits to Postgres because relation text_old_id_seq does not exist?
https://bugzilla.wikimedia.org/show_bug.cgi?id=21386 --- Comment #2 from Niels Olson niels.ol...@gmail.com 2009-11-02 15:46:29 UTC --- Turns out this was due to mediawiki changing the names of several sequences in the database. Refreshed all with pgAdmin, and everything works again. Wish that had been in the release notes or something. Was it and I'm just not seeing it? If so, where? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
