Index: openacs-4/packages/categories/sql/postgresql/categories-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/categories-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/categories/sql/postgresql/categories-create.sql	8 Feb 2004 17:30:45 -0000	1.4
+++ openacs-4/packages/categories/sql/postgresql/categories-create.sql	10 Feb 2004 11:55:08 -0000	1.5
@@ -7,41 +7,31 @@
 
           -- create the object types
 
-create function inline_0 ()
-returns integer as '
-begin
+select acs_object_type__create_type (
+    'category_tree',        -- object_type
+    'Category Tree',        -- pretty_name
+    'Category Trees',       -- pretty_plural
+    'acs_object',           -- supertype
+    'category_trees',       -- table_name
+    'tree_id',              -- id_column
+    'category_tree.name',    -- name_method
+    'f',
+    null,
+    null
+);
+select acs_object_type__create_type (
+    'category',             -- object_type
+    'Category',             -- pretty_name
+    'Categories',           -- pretty_plural
+    'acs_object',           -- supertype
+    'categories',           -- table_name
+    'category_id',          -- id_column
+    'category.name',         -- name_method
+    'f',
+    null,
+    null
+);
 
-    PERFORM acs_object_type__create_type (
-                ''category_tree'',        -- object_type
-                ''Category Tree'',        -- pretty_name
-                ''Category Trees'',       -- pretty_plural
-                ''acs_object'',           -- supertype
-                ''category_trees'',       -- table_name
-                ''tree_id'',              -- id_column
-                ''category_tree.name'',    -- name_method
-                ''f'',
-                null,
-                null
-        );
-    PERFORM acs_object_type__create_type (
-                ''category'',             -- object_type
-                ''Category'',             -- pretty_name
-                ''Categories'',           -- pretty_plural
-                ''acs_object'',           -- supertype
-                ''categories'',           -- table_name
-                ''category_id'',          -- id_column
-                ''category.name'',         -- name_method
-                ''f'',
-                null,
-                null
-        );
-
-    return 0;
-end;' language 'plpgsql';
-
-select inline_0 ();
-drop function inline_0 ();
-
 create table category_trees (
        tree_id			integer primary key 
                                 constraint cat_trees_tree_id_fk