From 2039710962db42e0b85a1ab452f923b921bce1b4 Mon Sep 17 00:00:00 2001 From: Habeas Codice Date: Wed, 28 Jan 2015 17:47:31 -0800 Subject: postgres does not support the , syntax. a ; would work, if it weren't statement-locked. FWIW, the exact same queries listed for postgres are perfectly valid and equivalent on mysql. no need for separate statements. --- install/update.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'install/update.php') diff --git a/install/update.php b/install/update.php index 346b2c25a..597da4e3b 100644 --- a/install/update.php +++ b/install/update.php @@ -1540,7 +1540,9 @@ function update_r1133() { function update_r1134() { if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) { - $r = q("ALTER TABLE xlink ADD xlink_static numeric(1) NOT NULL DEFAULT '0', create index xlink_static on xlink ( \"xlink_static\" ) "); + $r1 = q("ALTER TABLE xlink ADD xlink_static numeric(1) NOT NULL DEFAULT '0' "); + $r2 = q("create index xlink_static on xlink ( xlink_static ) "); + $r = $r1 && $r2; } else $r = q("ALTER TABLE xlink ADD xlink_static TINYINT( 1 ) NOT NULL DEFAULT '0', ADD INDEX ( xlink_static ) "); -- cgit v1.2.3