Closed (fixed)
Project:
Workflow
Version:
5.x-2.3
Component:
Code
Priority:
Normal
Category:
Feature request
Assigned:
Unassigned
Reporter:
Created:
21 Jul 2008 at 23:03 UTC
Updated:
5 Aug 2008 at 03:12 UTC
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.