https://bugzilla.wikimedia.org/show_bug.cgi?id=34855
Andrew Ruthven <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Andrew Ruthven <[email protected]> 2012-03-05 22:04:28 UTC --- The Postgres logs have: ser=wikiuser,db=wikidb ERROR: syntax error at or near ""smw_tmp_unusedprops"" at character 89 ser=wikiuser,db=wikidb STATEMENT: CREATE /* SMWSQLStore2::getUnusedPropertiesSpecial Andrew */ OR REPLACE FUNCTION create_"smw_tmp_unusedprops"() RETURNS void AS $$ BEGIN IF EXISTS(SELECT NULL FROM pg_tables WHERE tablename='"smw_tmp_unusedprops"' AND schemaname = ANY (current_schemas(true))) THEN DELETE FROM "smw_tmp_unusedprops"; ELSE CREATE TEMPORARY TABLE "smw_tmp_unusedprops" ( title text ); END IF; END; $$ LANGUAGE 'plpgsql'; SELECT create_"smw_tmp_unusedprops"(); The patch I've attached resolves this issue. -- 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
