Simplenews Postgres compatible

I'm not familiar with Postgres. From your patch I conclude that errors are generated by the double quotes inside a string? So instead of your patch, would this also solve the issue?

db_query("SELECT status FROM {blocks} WHERE module = '%s' AND delta = '%s'", ....

I guess it would, as it is standard style troughout simplenews, and you actually pointed out the exceptions... I committed this code, can you test it and set this issue to 'fixed' if all works?