aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--install/update.php5
1 files changed, 4 insertions, 1 deletions
diff --git a/install/update.php b/install/update.php
index f13243a93..fc6641c55 100644
--- a/install/update.php
+++ b/install/update.php
@@ -2449,7 +2449,10 @@ function update_r1182() {
function update_r1183() {
if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
- $r1 = q("alter table hook ALTER priority priority smallint NOT NULL DEFAULT '0' ");
+ $r1 = q("alter table hook ALTER COLUMN priority TYPE smallint");
+ $r2 = q("alter table hook ALTER COLUMN priority SET NOT NULL");
+ $r3 = q("alter table hook ALTER COLUMN priority SET DEFAULT '0'");
+ $r1 = $r1 && $r2 && $r3;
}
else {
$r1 = q("alter table hook CHANGE priority priority smallint NOT NULL DEFAULT '0' ");