Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
jvandyk CreditAttribution: jvandyk commentedThanks! Committed to DRUPAL-5 branch.
Comment #2
Anonymous (not verified) CreditAttribution: Anonymous commentedAutomatically closed -- issue fixed for two weeks with no activity.