https://bugzilla.wikimedia.org/show_bug.cgi?id=36087
--- Comment #4 from Pei-Tang Huang <[email protected]> 2012-04-19 11:18:51 UTC --- After checkout the proposed branch, I got another error: > ...index 'logging_page_id_time' on table 'logging' already exists > ...index 'iwl_prefix_title_from' on table 'iwlinks' already exists > Creating index 'job_timestamp_idx' on table 'job' (job_timestamp) > A database query syntax error has occurred. > The last attempted database query was: > " > SELECT opcname, > attname, > i.indoption[s.g] as option, > pg_am.amname > FROM > (SELECT generate_subscripts(isub.indkey, 1) AS g > FROM > pg_index isub > JOIN pg_class cis > ON cis.oid=isub.indexrelid > JOIN pg_namespace ns > ON cis.relnamespace = ns.oid > WHERE cis.relname='pagelink_unique' AND > ns.nspname='mediawiki') AS s, > pg_attribute, > pg_opclass opcls, > pg_am, > pg_class ci > JOIN pg_index i > ON ci.oid=i.indexrelid > JOIN pg_class ct > ON ct.oid = i.indrelid > JOIN pg_namespace n > ON ci.relnamespace = n.oid > WHERE > ci.relname='pagelink_unique' AND > n.nspname='mediawiki' > AND attrelid = ct.oid > AND i.indkey[s.g] = attnum > AND i.indclass[s.g] = opcls.oid > AND pg_am.oid = opcls.opcmethod" > from within function "DatabasePostgres::indexAttributes". > Database returned error "42883: ERROR: function > generate_subscripts(int2vector, integer) does not exist > LINE 7: (SELECT generate_subscripts(isub.indkey, 1) AS g > ^ > HINT: No function matches the given name and argument types. You might need > to add explicit type casts. > " I found that "generate_subscripts" function was introduced in PostgresQL 8.4, is PostgresQL 8.3 not supported by MediaWiki anymore? -- 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
