From 02e23b4f62975edbf7332984484c9b8a0e3a0850 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Thu, 31 Aug 2006 14:53:28 +0000 Subject: - Patch #81695 by sammys: fix cache indices on PostgreSQL. --- modules/system/system.install | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'modules/system/system.install') diff --git a/modules/system/system.install b/modules/system/system.install index 6335d08f2..9d20ae5d9 100644 --- a/modules/system/system.install +++ b/modules/system/system.install @@ -507,9 +507,9 @@ function system_install() { PRIMARY KEY (cid) )"); db_query("CREATE INDEX {cache}_expire_idx ON {cache} (expire)"); - db_query("CREATE INDEX {cache}_expire_idx ON {cache_filter} (expire)"); - db_query("CREATE INDEX {cache}_expire_idx ON {cache_menu} (expire)"); - db_query("CREATE INDEX {cache}_expire_idx ON {cache_page} (expire)"); + db_query("CREATE INDEX {cache_filter}_expire_idx ON {cache_filter} (expire)"); + db_query("CREATE INDEX {cache_menu}_expire_idx ON {cache_menu} (expire)"); + db_query("CREATE INDEX {cache_page}_expire_idx ON {cache_page} (expire)"); db_query("CREATE TABLE {comments} ( cid serial, @@ -3224,9 +3224,9 @@ function system_update_1009() { headers text, PRIMARY KEY (cid) )"); - $ret[] = update_sql("CREATE INDEX {cache}_expire_idx ON {cache_filter} (expire)"); - $ret[] = update_sql("CREATE INDEX {cache}_expire_idx ON {cache_menu} (expire)"); - $ret[] = update_sql("CREATE INDEX {cache}_expire_idx ON {cache_page} (expire)"); + $ret[] = update_sql("CREATE INDEX {cache_filter}_expire_idx ON {cache_filter} (expire)"); + $ret[] = update_sql("CREATE INDEX {cache_menu}_expire_idx ON {cache_menu} (expire)"); + $ret[] = update_sql("CREATE INDEX {cache_page}_expire_idx ON {cache_page} (expire)"); break; } return $ret; -- cgit v1.2.3