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.

Comments

fumanchu182’s picture

Status: Active » Needs review
jvandyk’s picture

Status: Needs review » Closed (duplicate)