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 commentedThanks! Committed to DRUPAL-5 branch.
Comment #2
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.