Thread:Extension talk:FlaggedRevs/PostgreSQL 9.0

I'm trying to install FlaggedRevs in Mediawiki 1.18.1.

At first I got the following error message: ValidationStatistics Warning: pg_query: Query failed: ERROR: function unix_timestamp(timestamp with time zone) does not exist

I created the function UNIX_TIMESTAMP(TIMESTAMP WITH TIME ZONE) using CREATE OR REPLACE FUNCTION UNIX_TIMESTAMP(TIMESTAMP WITH TIME ZONE) RETURNS BIGINT LANGUAGE SQL IMMUTABLE STRICT AS 'SELECT EXTRACT(EPOCH FROM $1)::bigint;'; from http://www.postgresql.org/docs/7.4/interactive/functions-datetime.html

Running updateStats.php now throws the following error: ValidationStatistics Warning: pg_query: Query failed: ERROR: invalid input syntax for type timestamp with time zone: "0" LINE 1: ... fr_rev_id = fpp_rev_id) AND (fpp_pending_since > '0') ORDE...                                                             ^ in [path to mediawiki]/includes/db/DatabasePostgres.php on line 253 Query: SELECT fpp_page_id,fpp_rev_id,fpp_pending_since,fr_timestamp FROM "flaggedpage_pending", "flaggedrevs" WHERE fpp_quality = '0' AND (fpp_pending_since > '2012-02-13 07:48:08 DMT') AND ( fr_page_id = fpp_page_id AND fr_rev_id = fpp_rev_id) AND (fpp_pending_since > '0') ORDER BY fpp_pending_since ASC LIMIT 1 Function: FlaggedRevsStats::getReviewTimesAnons Error: 1 ERROR: invalid input syntax for type timestamp with time zone: "0"

I'm using PostgreSQL 9.0, Mediawiki 1.18.1 from svn (REL1_18) and FlaggedRevs from svn (REL1_18).

Any thoughts?