PostgreSQL compatibility issue

Hi,

Installed comment notify; When it ran the db update stuff (after enabling the module) Drupal told me that it couldn't alter the table..

A quick look at the code showed the following :

ADD COLUMN `notify` tinyint(1) NOT NULL DEFAULT '1'"

which needed to be replaced with :

alter table comments add column notify int2 not null default 1;

Namely:
1) PostgreSQL doesn't like backticks (`)
2) PostgreSQL doesn't have a 'tinyint(1)' - but it does have an 'int2'.

thanks
David.