https://bugzilla.wikimedia.org/show_bug.cgi?id=21386
Michael Tutty <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED CC| |[email protected] Resolution|FIXED | --- Comment #8 from Michael Tutty <[email protected]> 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
