Some publish.module queries yield errors when running under PostgreSQL because string literals are wrapped in double quotes, which is unsupported by PG.

(The same applied to subscribe.module, so to reduce noise i'm posting patch here as well).