The SQL statements in the hook_install() and hook_update_n() functions is incompatible with PostgreSQL. The attached patch file includes an update to correct this.

The patch does two things:

  1. Changes the "`" field delimiter character into a computed value based on $db_type global variable.
  2. Changes the SQL in the UPDATE statements to be compatible with both MySQL and PostgreSQL databases.
CommentFileSizeAuthor
exclude_node_title-pgsql.patch1.81 KBjburkhard
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Simon Georges’s picture

Simon Georges CreditAttribution: Simon Georges commented
Status: Active » Needs review

Changing status, as there is a patch.

moskito’s picture

moskito CreditAttribution: moskito commented

This issue is the same of #1645344: Fatal error on postgresql - ERROR: syntax error at or near "`" LINE 1: INSERT INTO role_permission, that affect a different version. IMO, solution in #1645344 seems more simple and should be backported to 6.x version.

fizk’s picture

fizk CreditAttribution: fizk commented
Version: 6.x-1.6 » 6.x-1.x-dev
Status: Needs review » Closed (fixed)

Fixed, thanks!

http://drupalcode.org/project/exclude_node_title.git/commit/ea9afbd69653...