PostgreSQL error - null value in column notified

I'm seeing the following error:
query: INSERT INTO comment_notify (cid, notify, notify_hash) values (321, 0, 'eeedf4cd9fdd0132316f3ff46bbd6969') in /var/www/dev/sites/all/modules/comment_notify/comment_notify.module on line 271.

pg_query() [function.pg-query]: Query failed: ERROR: null value in column "notified" violates not-null constraint in /var/www/dev/includes/database.pgsql.inc on line 139.

This is because the column notified is set as NOT NULL but with no default value - in mysql the default is automatically 0, but in postgres it has no default.

Patch is attached