Index: openacs-4/packages/dotlrn-survey/sql/postgresql/dotlrn-survey-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-survey/sql/postgresql/dotlrn-survey-create.sql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/dotlrn-survey/sql/postgresql/dotlrn-survey-create.sql	13 Jan 2005 13:57:32 -0000	1.2
+++ openacs-4/packages/dotlrn-survey/sql/postgresql/dotlrn-survey-create.sql	27 Jun 2005 23:50:37 -0000	1.2.2.1
@@ -173,7 +173,7 @@
 begin
 	for c_one_survey in select s.*, o.creation_user
                           from surveys s, acs_objects o
-                          where package_id=p_old_package_id
+                          where s.package_id=p_old_package_id
                           and o.object_id=s.survey_id
 	loop
 	v_survey_id := survey__new(
@@ -235,4 +235,4 @@
            end loop;
         end loop;
 	return v_survey_id;
-end;' language 'plpgsql';
\ No newline at end of file
+end;' language 'plpgsql';