When I am using the nodeblock module with postgresql, I get the following error when going to admin/build/block :

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: column "block" does not exist LINE 1: SELECT nid, title FROM node WHERE type = "block" AND status ... ^ in /var/html/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT nid, title FROM node WHERE type = "block" AND status = 1 AND (nid = tnid OR tnid = 0) in /home/var/sites/all/modules/contrib/nodeblock/nodeblock.module on line 96.

According to this document:
http://drupal.org/node/555548

PostgreSQL does not allow double-quotes. You must use single quotes.

CommentFileSizeAuthor
#1 577246.patch774 bytesroychri

Comments

roychri’s picture

roychri commented
Status: Active » Needs review
StatusFileSize
new 577246.patch774 bytes

Here is my proposed patch.

tom_o_t’s picture

tom_o_t commented
Assigned: Unassigned » tom_o_t
Status: Needs review » Reviewed & tested by the community

Thanks for the patch. Will roll this next time I'm working on the module.

tom_o_t’s picture

tom_o_t commented
Status: Reviewed & tested by the community » Fixed

Committed to head.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.