From ab633dad9b5854ca7d21f9c4c75aab3a5523c3ef Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Tue, 16 Aug 2005 19:54:36 +0000 Subject: - Patch #28986: fixed Incorrect order of PosgreSQL statements. --- database/updates.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'database') diff --git a/database/updates.inc b/database/updates.inc index e57ed1742..28634854f 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -2474,9 +2474,9 @@ function update_137() { elseif ($GLOBALS['db_type'] == 'pgsql') { $ret[] = update_sql("ALTER TABLE {locales_source} RENAME location TO location_old"); $ret[] = update_sql("ALTER TABLE {locales_source} ADD location varchar(255)"); + $ret[] = update_sql("UPDATE {locales_source} SET location = location_old"); $ret[] = update_sql("ALTER TABLE {locales_source} ALTER location SET NOT NULL"); $ret[] = update_sql("ALTER TABLE {locales_source} ALTER location SET DEFAULT ''"); - $ret[] = update_sql("UPDATE {locales_source} SET location = location_old"); $ret[] = update_sql("ALTER TABLE {locales_source} DROP location_old"); } return $ret; -- cgit v1.2.3