diff options
| -rw-r--r-- | install/update.php | 5 |
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' "); |