cron notifications fail with Postgres

if you set up a subscription, then do the "run cron manually" (1), you get an error message:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: integer = character varying LINE 1: ...ments c INNER JOIN subscriptions_queue q ON c.cid = q.load_a... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /home/chris/vijay/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT q.sqid AS _subscriptions_sqid, q.is_new AS _subscriptions_is_new, c.* FROM comments c INNER JOIN subscriptions_queue q ON c.cid = q.load_args AND q.uid = 6 AND q.load_function = 'subscriptions_content_comment_load' WHERE c.nid = 8 AND c.status = 0 in /home/chris/vijay/sites/all/modules/subscriptions/subscriptions_content.module on line 664.

the solution is to change subscriptions_content.module, line 664 from:

$sql = "SELECT q.sqid AS _subscriptions_sqid, q.is_new AS _subscriptio     ns_is_new, c.* FROM {comments} c INNER JOIN {subscriptions_queue} q ON c.cid = q.load_args AND q.uid = %d AND q.load_function = '%s'      WHERE c.nid = %d ". $published_comments_only .' '. $limit_sqids;

to

$sql = "SELECT q.sqid AS _subscriptions_sqid, q.is_new AS _subscriptio     ns_is_new, c.* FROM {comments} c INNER JOIN {subscriptions_queue} q ON CAST     (c.cid as VARCHAR) = q.load_args AND q.uid = %d AND q.load_function = '%s'      WHERE c.nid = %d ". $published_comments_only .' '. $limit_sqids;

(note the CAST())