Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.7d-4.7.2d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.7d-4.7.2d.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.7d-4.7.2d.sql	17 Feb 2003 23:57:07 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.7d-4.7.2d.sql	18 Feb 2003 08:54:55 -0000	1.2
@@ -1 +1,18 @@
-insert into apm_package_file_types(file_type_key, pretty_name) values(''message_catalog'', ''Message Catalog'');
+create function inline_0 ()
+returns integer as '
+declare
+  v_catalog_type_exists_p integer;
+begin
+	select count(*) into v_catalog_type_exists_p 
+	from apm_package_file_types where file_type_key = ''message_catalog'';
+
+	if v_catalog_type_exists_p = ''0'' then
+          insert into apm_package_file_types(file_type_key, pretty_name) 
+               values(''message_catalog'', ''Message Catalog'');
+	end if;
+
+	return 1;
+end;' language 'plpgsql';
+
+select inline_0 ();
+drop function inline_0 ();