Closed (duplicate)
Project:
Workflow
Version:
5.x-2.3
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
20 Nov 2008 at 22:22 UTC
Updated:
29 Dec 2008 at 20:25 UTC
The PostgreSQL installation fails. Take a look at the following patch that has it working on my development system.
--- workflow_access.install 2008-11-20 14:17:11.000000000 -0500
+++ workflow_access.install 2008-11-20 14:30:00.000000000 -0500
@@ -31,9 +31,9 @@ QUERY
CREATE TABLE {workflow_access} (
sid SERIAL,
rid integer NOT NULL default 0,
- grant_view smallint unsigned NOT NULL default 0,
- grant_update smallint unsigned NOT NULL default 0,
- grant_delete smallint unsigned NOT NULL default 0,
+ grant_view smallint NOT NULL default 0,
+ grant_update smallint NOT NULL default 0,
+ grant_delete smallint NOT NULL default 0
);
QUERY
);
@@ -42,6 +42,7 @@ QUERY
CREATE INDEX {workflow_access}_rid_idx ON {workflow_access}(rid);
QUERY
);
+ break;
}
}
Also attached is the patch for review. Unsigned is explicit on PostgreSQL if you are looking to do a constrain as such I would recommend the CHECK syntax in PostgreSQL.
| Comment | File | Size | Author |
|---|---|---|---|
| 20081120.postgres.workflow_access.install.patch | 681 bytes | fumanchu182 |
Comments
Comment #1
fumanchu182 commentedComment #2
jvandyk commentedhttp://drupal.org/node/285543