Last modified: 2010-05-26 18:08:37 UTC
In install procedure of the extension : http://www.mediawiki.org/wiki/Extension:FlaggedRevs#Setup Point 7 # \i FlaggedRevs.pg.sql # psql:FlaggedRevs.pg.sql:24: ERREUR: erreur de syntaxe sur ou près de « UNSIGNED » LINE 2: fpp_page_id INTEGER UNSIGNED NOT NULL, Fix : replace Integer unsigned by BIGINT as suggested here : http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL#Data Types CREATE TABLE flaggedpage_pending ( fpp_page_id BIGINT NOT NULL, fpp_quality INTEGER NOT NULL, fpp_rev_id BIGINT NOT NULL, fpp_pending_since TIMESTAMPTZ NULL, PRIMARY KEY (fpp_page_id,fpp_quality) );
Done in r66928