Workflow Access fails to install on postgres due to invalid SQL.

The correct workflow_access.install code for case 'pgsql' is

<?php
    case 'pgsql':
      $result[] = db_query(
<<<QUERY
CREATE TABLE {workflow_access} (
  sid SERIAL,
  rid integer NOT NULL default 0,
  grant_view int_unsigned NOT NULL default 0,
  grant_update int_unsigned NOT NULL default 0,
  grant_delete int_unsigned NOT NULL default 0
);
QUERY
      );
      $result[] = db_query(
<<<QUERY
CREATE INDEX {workflow_access}_rid_idx ON {workflow_access}(rid);
QUERY
      );
?>

hope that helps someone.

DT

Comments

jvandyk’s picture

Status: Active » Fixed

Thanks! Committed to DRUPAL-5 branch.

Anonymous’s picture

Status: Fixed » Closed (fixed)

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