The following useful modules aren't working with Drupal 4.3.2 and PostgreSQL
- Subscriptions - allows users to subscribe to topics or specific articles to be mailed if there are new posts.
- Notify - like subscriptions except that its a simple yes or no to be notified for any content updates site wide.
One or both of these modules would help AWG members keep informed and participate in discussions on the site. The other alternate is of course RSS with a feed reader, but I am not sure if that will include comments.
I have posted bug reports on each of these two items. I will include them below and then will update with any troubleshooting.
Okay I worked with Adrian, the postgres drupal maintainer, and the first problem with the susbcriptions module is that no .pgsql table creation was included. So Adrian gave me a dump to use.
CREATE TABLE subscriptions( sid integer not null, uid integer not null, stype text not null );
The table was created and I was able to enable the module in the web based module administration tool. But when enabled pgsql errors showed up in the browser. So my guess is that the module itself modules/subscriptions.module has some mysql specific calls that need fixing.

