Index: openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.2b3-1.2b4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.2b3-1.2b4.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.2b3-1.2b4.sql	15 Feb 2006 10:06:36 -0000	1.1
+++ openacs-4/packages/contacts/sql/postgresql/upgrade/upgrade-1.2b3-1.2b4.sql	15 Feb 2006 10:11:01 -0000	1.2
@@ -24,7 +24,7 @@
 	v_package_id := package_id from apm_packages where package_key = ''contacts'';
 
         update acs_objects
-           set title = ( select cs.title from contact_searches where cs.search_id = acs_objects.object_id ),
+           set title = ( select cs.title from contact_searches cs where cs.search_id = acs_objects.object_id ),
                package_id = v_package_id
          where object_id in ( select c.search_id from contact_searches c );